I have an Excel Document that has the following columns:
A11 = Date In (Date Format)
B11 = Time In (Time Format)
C11 = Date Out (Date Format)
D11 = Time Out (Time Format)
We need to calculate the amount of hours and minutes between the two date and time period.
How can this be done?
Screenshot of the spreadsheet setup attached.