LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,814
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering Seconds but displaying minutes & seconds DaveWHAC Excel Discussion (Misc queries) 7 October 20th 06 02:14 PM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
Converting hours:minutes:seconds to just minutes Dan Vagle Excel Worksheet Functions 3 July 17th 06 11:20 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM
Convert seconds to minutes and seconds in excel anonymous Excel Worksheet Functions 3 December 25th 04 08:38 PM


All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"