| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i change hours and minutes into a decimal number?
i am trying to turn total flight hrs into a decimal number( ie: 2045hrs
10mins into 2045.10). can anyone help me with a formula which may help in this? time is given HH:MM but i need it turned to HH.M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change hours and minutes into a decimal number? | New Users to Excel | |||
| Change time h:mm to a decimal number based on hours | Excel Worksheet Functions | |||
| Convert Decimal hours and Minutes to minutes please. | Excel Worksheet Functions | |||
| Hours & Minutes to Decimal | Excel Discussion (Misc queries) | |||
| how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
Threaded Mode
