The maximum *manual* time entry is 9999:99:99.

You can enter 32570:57 in the cell but it will be a *TEXT* string. You can
still use that value in your calculation:

=LEFT(A1,FIND(":",A1)-1)*24+RIGHT(A1,2)/60

result: 781680.95

Biff

"Nauj Solrac" wrote in message
...
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.