Time calulations

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 as Time 37:30:55

Jerry

Dave Elenor wrote:

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

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


"Dave Elenor" <[email protected]> wrote in message
news:[email protected]...
>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
"Dave Elenor" <[email protected]> wrote in message
news:[email protected]...
>
> if i work 13 hours a day 6 days a week how do I total it up to one figure
>
>
> "Dave Elenor" <[email protected]> wrote in message
> news:[email protected]...
>>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.
>>
>
>

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.

In article <[email protected]>,
"Dave Elenor" <[email protected]> wrote:

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