Hi,
Need a help on this query: I need to compute the number of Voluntary Time Off within 8 hours shift.
Example:
B4 = 5:00 PM - 2:00 AM <---- Shift Line
B5 = 5:00 PM <---- log in time
C5 = 12:11 AM <--- log out time due to VTO
D5 = 1:49 <--- VTO hours
How will I be able to do this to avoid computing it manually?
Bookmarks