help with adding up hours and mins please

[baz]

Hi I am trying to add up the total number of hours worked by staff over a
montly period by inserting times in colums for days 1 - 31. When I add
formula =sum(a1:a31) the total is way out because the times mins are being
treated as tenths and hundreths and the total for hours gets to 24 then
reverts back to one.

how do I get hours and mins to add up as hours and mins ?

Cheers

Baz

 

[T. Valko]

Format the the total cell as [h]:mm

The [ ] will keep the hours from rolling over.

 

[baz]

T - Spot on Thank you - just done a dummy test and it looks ok - can go to
work on Monday and be a right smarty pants !!!

regards

Baz

Format the the total cell as [h]:mm

The [ ] will keep the hours from rolling over.

--
Biff
Microsoft Excel MVP

Hi I am trying to add up the total number of hours worked by staff over a
montly period by inserting times in colums for days 1 - 31. When I add
formula =sum(a1:a31) the total is way out because the times mins are being
treated as tenths and hundreths and the total for hours gets to 24 then
reverts back to one.

how do I get hours and mins to add up as hours and mins ?

Cheers

Baz

 

[T. Valko]

Cool! Thanks for the feedback!

--
Biff
Microsoft Excel MVP

T - Spot on Thank you - just done a dummy test and it looks ok - can go to
work on Monday and be a right smarty pants !!!

regards

Baz

Format the the total cell as [h]:mm

The [ ] will keep the hours from rolling over.

--
Biff
Microsoft Excel MVP

Hi I am trying to add up the total number of hours worked by staff over
a
montly period by inserting times in colums for days 1 - 31. When I add
formula =sum(a1:a31) the total is way out because the times mins are
being
treated as tenths and hundreths and the total for hours gets to 24 then
reverts back to one.

how do I get hours and mins to add up as hours and mins ?

Cheers

Baz