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

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

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

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

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

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.


--
John C


"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

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

Thanks guys,

much appreciated.

"Pete_UK" wrote:

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

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

You're welcome.

Pete

On Jul 11, 6:28*pm, Steve wrote:
Thanks guys,

much appreciated.



"Pete_UK" wrote:
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