Thanks Ron,

I already wrote back after it was pointed out that the brackets had to be
inserted. Works great now!

Patrick

"Ron Rosenfeld" wrote:

On Sun, 9 Jan 2005 12:21:03 -0800, "Patrick"
wrote:

Bob, the format is fine. It's just that when you get to 24:00 it switches
back to 0:00. I need it to keep adding all the way up to 70:00.

Patrick

"Bob Phillips" wrote:

Just format the total cell as [hh]:mm


Patrick,

Reread Bob's answer and note the brackets around the h in the format he
recommended.

The behavior you describe is seen when you do NOT format it as Bob recommended.

In other words:

h:mm rolls over at 24
[h]:mm does NOT roll over at 24


--ron