Sum hours
 

How do I sum or total up hours when the total goes over 23:99? Excel tend to
revert back to 0:00 once it reach 24:00.

Sum hours
 

Format the cell as [h]:mm

The brackets keep the hours from rolling over.

Biff

"JJ Goh" <JJ wrote in message
...
How do I sum or total up hours when the total goes over 23:99? Excel tend
to
revert back to 0:00 once it reach 24:00.