Hi, I've been working for long time with this formula but now, some times,
need to enter values greater tha 9999:59, i.e.
A1=32570:57
B1=A1*24 -- I got "#VALUE!" as a result
Is there any formula to get the decimal amount when I enter manually
32570:57; Please let me know
Thanks
'Nauj Solrac'

"Frank Kabel" wrote:

Hi
if this time value is in A1 enter the following formula
=A1*24
and format this cell as 'Number'

--
Regards
Frank Kabel
Frankfurt, Germany


CRAIG.JOHNSON wrote:
Wish modify my time card worksheet to display weekly totals in a
decimal Hour number only (instead of the current Hour:Minute:Second)
format (i.e., would like to convert 43 HR: 30 MN: 00 SEC to 43.5 HR).
Have looked at the TIME and TIME VALUE functions and they do not
appear to do what I would like.