| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Decimal time
I need to convert regular time to decimal time. example regular time in A1
is 1:38 I need that number to be converted to decimal time = to 13:63. add 12 to the hour and divide 38 into 60 to get the minutes. Our time clock prints on a 12 hour basis and I enter to excel in decimal time. Any suggestions? -- Kim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!! | Excel Discussion (Misc queries) | |||
| If Statement - in time not decimal minutes | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Threaded Mode
