Hi!

Format the total cell as [h]:mm.

The [ ] keeps the hours from rolling over back to zero after 24 hours is
reached.

Biff

"simon, uk" <simon, wrote in message
...
How do I add time, in the hr:mn format, and view total time in the same
hr:mn
format when the total time is greater than 23:55?