Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Entering Seconds but displaying minutes & seconds | Excel Discussion (Misc queries) | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions |