Minutes/seconds not right ( 24 ??? %$@#$%$)

[Steve]

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

 

[Pete_UK]

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

 

[John C]

Not sure where column K comes into play, but you could do the following,
assuming your data starts in row 2, type in cell D2:

=TEXT(SUM(A$2:A2)/60/60/24,"mm:ss")

and copy down as far as needed.

 

[Steve]

Thanks guys,

much appreciated.

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

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

 

[Pete_UK]

You're welcome.

Pete

Thanks guys,

much appreciated.

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