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.