LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
John
 
Posts: n/a
Default Problems with time

I would be grateful if someone could help me with this:

I often have the need to show the elapsed time between two cells where cell
one has say 22:30 and cell two has 04:30 (which would be the time the next
morning). Imagine a car starting it's journey at 22:30 and reaching it's
destination 6 hours later. It's easy if the times are on the same day but go
past midnight and I find it impossible so have to take my socks off to do
the calculation.

Following that (and here imagine lots of car journeys) I then have a
problem summing all of the outputs if I want to show the hours or minutes
total of many calculations, say 73 hours or 4380 minutes. I've tried
customising formats but so far all my fiddling about with combinations of hh
or mm or even mn have proved fruitless.

Hopefully some kind person can give me a nudge in the right direction.

Regards ..................... John


 
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 time damezumari Excel Discussion (Misc queries) 2 June 20th 05 08:35 PM
More problems displaying a negative time SheriffCassidy Excel Discussion (Misc queries) 1 June 3rd 05 02:15 AM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM
Am trying to make a time sheet and having problems with a formula. godnight Excel Worksheet Functions 2 February 14th 05 01:21 PM
time and date problems still Michaela Excel Worksheet Functions 0 February 7th 05 05:31 PM


All times are GMT +1. The time now is 12:28 PM.

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"