Format the the total cell as [h]:mm

The [ ] will keep the hours from rolling over.

--
Biff
Microsoft Excel MVP


"baz" wrote in message
...
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