JDT

Me thinks you didn't read the reply ;-)

FormatCells...Custom and enter [hh]:mm

Note the [ ]. It stops the hours incrementing to days over 24, likewise
[mm]:ss will stop minutes incrementing to hours over 60

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"JDT" wrote in message
...
On Tue, 1 Feb 2005 22:55:39 -0000, "Nick Hodge"
wrote:

DT

Format the cells to [hh]:mm through Formatcells...numbercustom

I tried formatting using the FormatCellsTime hh:mm and I also tried
FormatCustom h:mm and neither one worked.

Let's say in A1 I input the time in and in A2 I input the time out.
The amount of time worked will be A2-A1 in A3. Now, in A4 I want the
cumulative total of A3 as I add data down the list. The way I "was"
doing it worked fine until the total exceeded 24 and then it went to
0:00.

Either way I try it all I come up with is zeros.

Thanks.

JDT