Time calulations

[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.

 

[Jerry W. Lewis]

Format as Time 37:30:55

Jerry

 

[Dave Elenor]

if i work 13 hours a day 6 days a week how do I total it up to one figure

 

[CarlosAntenna]

Format the cell with the sum as follows:
Format>Cells>Number>Custom>Type: [hh]:mm

-- Carlos

 

[JE McGimpsey]

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.