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 givesA1 01-01-01-2014 12:00:00 =B1+"6:00"
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