Hours per day over multiple days - wait times

[ericsr128]

Example

I arrive at the train station 6/24/2011 7:42:00 PM
and I depart the train station 6/25/2011 2:24:00 AM

Keep in mind I have arrive times that start in the AM which adds to the complexity

arrive 6/25/2011 6:01:00 AM
depart 6/26/2011 4:14:00 PM



I want to capture the waiting time on 6/24 and 6/25
so I envision 2 columns. Day 1 wait is 4 hours 18 mins and Day 2 wait is 2 hours 24 mins.


Any suggestions ??????

[Ace_XL]

A simple Depart minus Arrive formatted as "h:mm" will do the trick. No need to separate into different columns

Alternatively,

=DATE(YEAR(A1),MONTH(A1),DAY(A1)+1)+TIME(0,0,0)-Arrive
=Depart-DATE(YEAR(A1),MONTH(A1),DAY(A1)+1)+TIME(0,0,0)

[ericsr128]

Very nice !

What if I wanted 3 "days" of wait times ?

arrive 6/5/2011 7:50PM
depart to final location 6/7/2011 4:37PM

6/5 = 4hr 10m
6/6 = 24hr
6/7 = 16hr 37m

Wonder if it's something I can do in a nested if where I just plug 24hrs for the second day and do the calcs in day 1 and 3.