If you have in B1:

=A1/60

and in C1:

=B1/60

then C1 represents hours. To get this into Excel time format you must
divide by a further 24:

=C1/24

then you can format this cell as [mm]:ss to ensure that the minutes
don't wrap around if they exceed 60.

Hope this helps.

Pete


On Jul 11, 4:40*pm, Steve wrote:
Column A is total time in seconds
Column B is A/60 - for minutes
Column C is B/60 - for minutes/seconds ??
In Column D, I'm running the total with these formulas =SUM($K$6:K12)
($K$6:K13), etc., in the D column.
This particular formula * * =SUM($K$6:K12)
*is in the *0:04 <------ cell below
The running time seems to work for the most part (1:46, 2:41, 4:57, etc.),
but when it gets past the 17:40 time, it produces 0:04 instead of 24:04. The
same thing further down with the <---- 6:27.

I'm sure it's something do do with the 24 that I don't have right. Any help
would be greatly appreciated.

Thanks,

Steve
* * * * /60 * * /24 * *
Seconds Minutes Mins/Secs * * * Running Time
106.05 *1.77 * *1:46 * *1:46
55.55 * 0.93 * *0:55 * *2:41
136.35 *2.27 * *2:16 * *4:57
65.65 * 1.09 * *1:05 * *6:03
479.75 *8.00 * *7:59 * *14:03
217.15 *3.62 * *3:37 * *17:40
383.8 * 6.40 * *6:23 * *0:04 * <-----
287.85 *4.80 * *4:47 * *4:52
156.55 *2.61 * *2:36 * *7:28
308.05 *5.13 * *5:08 * *12:36
85.85 * 1.43 * *1:25 * *14:02
424.2 * 7.07 * *7:04 * *21:06
166.65 *2.78 * *2:46 * *23:53
393.9 * 6.57 * *6:33 * *6:27 * <-----
126.25 *2.10 * *2:06 * *8:33