| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Assume you are totalling in A3: =SUM(A1:A2)
Just amend the formula in A3 to : =SUM(A1:A2)*24 then format A3 as General (or as Number) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Guy" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
