Hi! I need help on this one:
example:
A1 (Start time): 7/25/2017 8:00 AM
B1 (Breaktime Start): 12:00 PM
C1 (Breaktime End): 1:00 PM
D1 (End time): 7/27/2017 9:00 AM
E1 (Total time in d/ h/ m): =(D1-A1+(A1<D1)-($C$1-$B$1+($B$1<$C$1)))
The answer on E1 should be 2 days/ 1 hr/ 0 min. My problem with this one is that it subtracts the breaktime (1hr) even though it is not applicable.
Hope you could help!
Thanks.
Bookmarks