If my shift times are 9:00 till 17:00 hr and I need to work 6 hours on this help, how to count the time futher to the next day?
this gives![]()
Please Login or Register to view this content.
01-01-01-2014 18:00:00
Since I quit at 17:00 i need to work 1 hour left the next day.
Output must be:
01-01-01-2014 12:00:00
=B1+"6:00"
02-01-01-2014 10:00:00
Bookmarks