Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round/Display (HR:MN:SEC) data in decimal HR format for Time C
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
unable to change date format on imported data | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Cell data format | Excel Discussion (Misc queries) | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions |