Convert Date and Time to DateTime (Timestamp)

There are four fields - Date In , Time In, Date Out, Time Out
Date fields are Type = Date , Time fields are Type = Time

I need to convert “Date In” and “Time in” to a DateTimeIn (Timestamp)
I need to convert “Date Out” and “Time Out” to a DateTimeOut (Timestamp)
Then,
I need to calculate the duration of (DateTimeOut - DateTimeIn) and result in number of minutes

Thanks.

0 5 969
5 REPLIES 5
Top Labels in this Space