| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert [h]:mm sum total format to number format
I total time cards in [h]:mm format and would like to convert the total to a
number format displayed as hh.00 where the number of hours is the same but the minutes would display in decimal format. Example; total = 25:30 (25 hours, 30 minutes) and I want to convert that to read as 25.5 hours. -- GT |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Global fix for scientific number format? | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
