Good afternoon, I am attempting to convert mm/did/yyy hh:ss AA/PM to a serial number format with the minutes and seconds. I have used CDate and DateValue and continue to get a whole number. not sure what I am missing. Any assistance would be helpful.