Time durations

  • Thread starter Thread starter Andrew Z Carpenter [Newsgroup Groupie]
  • Start date Start date
A

Andrew Z Carpenter [Newsgroup Groupie]

Hi folks,

I need help. I have a list in a column of times in
24-hour format, like the following:

....
21:00
21:30
22:00
23:00
00:00
01:00
01:30
02:00
02:30
....

I have versions of the times with or without the
colon, which I've generated using LEFT and RIGHT.

What I need in another column is how many minutes
need to pass before reaching the next item.

So, it should look like the following:

.... ...
21:00 30
21:30 30
22:00 60
23:00 60
00:00 60
01:00 30
01:30 30
02:00 30
02:30 ...
.... ...

The times are not always limited to 30 or 60 minutes,
they could be any amount.

So, I'm stuck, and the added difficulty of midnight
has me really confused. Can anyone help me please?

Thank you!

Andrew
Excel dunce.
 
Hi again,

Thanks to a post from yesterday (slaps my own wrists) by
Ron de Bruin, in the thread started by Scooterdog called
<<<Wait Time & Overtime>>, I made my way to the following
website: http://www.cpearson.com/excel/overtime.htm

There, I applied their methodology to my problem, and came
up with the following solution:

=((end time-start time+(end time<start time))*24)*60

It gives me exactly the results I needed!

Thanks Ron, and I'm sorry I didn't look further down before
asking my question. I hate it when people do that ;-)

I will probably be back, as Excel isn't my forté!

Thanks again,

Andrew
 
Back
Top