Barry Kay
asked on
excel, office, formula, calulate
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER