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: 2
Default Adding up minutes

I looked, and saw several related subjects, but none that matched mine. I am
setting up a spreadsheet for running times on trains. I have running times
for certain sections of the main, but I need to build a chart that will
initially add minutes together. For instance:

00:13 minutes+00:05 Minutes and the result showing 00:18 Minutes. But the
sheet will be adding a lot of these together, and eventually it will end up
being hours instead of minutes. So it goes like this:

a1 00:13 + b2 00:05 = b1 00:18 + c3 00:35 = c2 00:53 + d4 00:15 * d3 01:08
and so on. I need it so that as running times change due to conditions, I can
simply change them, and the sheet will automatically recalculate all of the
dependent cells. I have one chart that has 15 separate times resulting in
03:48 hrs of time.


 
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
Adding hours and minutes Patrick Excel Worksheet Functions 16 June 18th 08 09:24 PM
ADDING MINUTES FC Excel Discussion (Misc queries) 7 October 2nd 07 02:31 AM
Adding minutes to Times ricky Excel Worksheet Functions 4 August 7th 06 04:39 PM
Adding minutes. Steved Excel Worksheet Functions 2 May 25th 06 12:26 AM
Adding minutes & seconds Emily16 Excel Discussion (Misc queries) 5 October 13th 05 10:01 PM


All times are GMT +1. The time now is 12:11 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"