Seifeddine87
Board Regular
- Joined
- Sep 7, 2015
- Messages
- 128
- Office Version
- 2016
- 2011
- 2010
i want to calculate the labour timing shift start at 9am till 12pm / 13pm till 17pm some times the order take more then one day
i am looking for a formula or function to give me the TOTAL as showing in the example thank you
EXAMPLE
i am looking for a formula or function to give me the TOTAL as showing in the example thank you
EXAMPLE
A | B | C | D | |
1 | engine | 25-08-20/9:30 | labour timing | 4H:55 |
2 | gearbox | 25-08-20/9:40 | 9:00 | |
3 | door | 25-08-20/11:20 | (11:20)-(9:30) =1h50m | 12:00 |
4 | bonnet | 25-08-20/14:50 | (15:35)-(14:50)=45m | 13:00 |
5 | bumper | 25-08-20/15:35 | (12:00)-(10:10)=1h50m | 17:00 |
6 | wing | 26-08-20/10:10 | (17:00)-(16:30)=30m | |
7 | boot | 26-08-20/16:30 | TOTAL 4h55m |