Time calulations

  • Thread starter Thread starter Dave Elenor
  • Start date Start date
D

Dave Elenor

I have weekly time calulations I need calulate but having problems.

in cell

A1 12:15
B1 11:50
C1 13:15

When I total all three cells I am getting a total of 13:15, what am I doing
wrong.
 
Format the cell with the sum as follows:
Format>Cells>Number>Custom>Type: [hh]:mm

-- Carlos
 
You use SUM(A1:F1) and format the result with

Format/Cells/Number/Custom [hh]:mm

The brackets prevent the hours from rolling over after 24.
 
Back
Top