Convert [h]:mm sum total format to number format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top