| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert dd:hr:mn:ss to Decimal number of hours
Hi all, can anyone help with how to convert days/hours/minutes/seconds of
time into a decimal number of hours. I tried the INT command which I've used before for hours but it only converts the hours in my original cell?? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert dd:hr:mn:ss to Decimal number of hours
One way:
XL stores times as fractional days, so where A1 contains the dd:hh:mm:ss, =A1*24 Format the cell as general or another number format. In article , Virginia wrote: Hi all, can anyone help with how to convert days/hours/minutes/seconds of time into a decimal number of hours. I tried the INT command which I've used before for hours but it only converts the hours in my original cell?? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Hours to Decimal | Excel Worksheet Functions | |||
| converting a decimal number to hours and seconds | Excel Worksheet Functions | |||
| How do I sum hours in Excel and convert to decimal numbers? | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Linear Mode
