date/time calc --- date and times are in different columns

[dmj120]

I've tried searching, and did find several threads about calculating time, but I didn't see anything that really connected with what I'm trying to do.

So I have a table with an "entry date/time" and "exit date/time" (see example). The time columns are formatted [$-F40]h:mm AM/PM. What I'd like to do is calculate the time (in hours) between the entry to exit times; and if the it goes across days, include the days. I'm not really firm on the "total time" format, I just want to be able to identify the number of days and hours if it goes multiple days, otherwise a simple hours/minutes will be cool.

Any ideas??

Something like:

Entry		Exit		Total time
8/15/2017	1:30 pm	8/15/17	2:30 pm	1 hour
8/15/2017	12:00 pm	8/20/2017	1:30 pm	5 days 1 hour 30 minutes

<tbody>
</tbody>

 

[AhoyNC]

Re: date/time calc --- date and times are in diffeent columns

Maybe something like this:
Under Format-Custom enter:

d "day(s)" h "hour(s)" mm "minutes"

<colgroup><col width="265"></colgroup>

Excel Workbook
	A	B	C	D	E
1	Entry		Exit		Total time
2	8/15/2017	1:30 PM	8/15/2017	2:30 PM	0 day(s) 1 hour(s) 00 minutes
3	8/15/2017	12:00 PM	8/20/2017	1:30 PM	5 day(s) 1 hour(s) 30 minutes
Sheet

 

[dmj120]

Re: date/time calc --- date and times are in diffeent columns

Sweet, thanks!!

 

[AhoyNC]

Re: date/time calc --- date and times are in diffeent columns

You're welcome. Thanks for the feedback.