ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Time scheduling (https://www.excelbanter.com/excel-worksheet-functions/29484-time-scheduling.html)

Geoff

Time scheduling
 
Trying to use Excel to schedule rather than projects.
current format works fine in 24 hour situation
1 cell has start time 0800 then when I add 12 hours work to this time in
next cell I get 2000hrs.
How do I get it to go to 1200 hours the next day with 1600 hours being
finish worktime the previous day
Any one??


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com