Convert Time to Numeric Value

[smithsd]

How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. Is there a way to do this by manual formula?

 

[Aladin Akyurek]

On 2003-01-23 12:26, smithsd wrote:
How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. Is there a way to do this by manual formula?

A true time entry like 11:30 is a 'numeric' value.

If a time entry has text as underlying format, then...

=TIMEVALUE(A1)

would convert it to true time value.

 

[phantom1975]

WELCOME TO THE BOARD!

Have you tried entering your time in a cell and then formatting the cell to a number? When doing so, 10:33AM turns into .44444444.

 

[Mark W.]

On 2003-01-23 12:26, smithsd wrote:
How do I convert time to a numeric value? I have tried the "TIMEVALUE" function and get an error message. Is there a way to do this by manual formula?

Excel's time values are stored as fractions of a day. If you need to convert a time such as 11:24 AM into hours, minutes or seconds merely multiply by 24, 1440 or 86400 respectively, and then format the results using a desired number format to get 11.4 hours, 684 minutes or 41,040 seconds.
This message was edited by Mark W. on 2003-01-23 12:47