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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Entry[/TD]
[TD][/TD]
[TD]Exit[/TD]
[TD][/TD]
[TD]Total time[/TD]
[/TR]
[TR]
[TD]8/15/2017[/TD]
[TD]1:30 pm[/TD]
[TD]8/15/17[/TD]
[TD]2:30 pm[/TD]
[TD]1 hour[/TD]
[/TR]
[TR]
[TD]8/15/2017[/TD]
[TD]12:00 pm[/TD]
[TD]8/20/2017[/TD]
[TD]1:30 pm[/TD]
[TD]5 days 1 hour 30 minutes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

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

Maybe something like this:
Under Format-Custom enter:
[TABLE="width: 265"]
<colgroup><col width="265"></colgroup>[TR]
[TD="width: 265"]d "day(s)" h "hour(s)" mm "minutes"
[/TD]
[/TR]
[/TABLE]

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.