Converting Date/Time to a numeric value

Posted by Marti Ryan on November 17, 2000 12:43 PM

HELP ME! Is there (and I am SURE there is) a way to convert a calculated time to a real numeric value such as you would use in a Time sheet spread? I sure would appreciate your help!

Posted by Ben O. on November 17, 2000 2:01 PM

Assuming your time value is in A1, here's how to convert it:

=DAY(A1)*24+HOUR(A1)+MINUTE(A1)/60

If your time value is accurate up to the second, add +SECOND(A1)/36000

You can omit DAY(A1) if your time values are all under 24 hours.

-Ben