Diving_Dan
Board Regular
- Joined
- Oct 20, 2019
- Messages
- 161
I've got an excel sheet where dates and times are put into the sheet via a userform. I am trying to work out the difference in hours and minutes between a date in a cell & time in another cell and the date and time in 2 other cells. I tried the following formula.
Is it possible to do this or would I need to have the date and time in a single cell rather than split across two different cells?
Any help will be appreciated
Excel Formula:
=TEXT(([@[Date leave]]+[@[Time leave]])-([@[Date arrived]]+[@[Time arrived]]),"HH:MM")
Any help will be appreciated