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?


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