CALCULATE TOTAL HOURS.. INCUDING ALL DAYS..

[LOHITKUMAR]

ACTUALY. WE ARE WORKING FROM 06:00HRS TO 22:00HRS DAILY.. WE RECEIVING RAKES DAILY... IF IT PLACED FOR UNLOADING START TIME IS AT 01-01-2022 14:00HRS.. UNLOADING WILL BE COMPLETING END TIME ON 02-01-2022 08:00HRS.. AS PER OUR WORKING HOURS TOTAL TIME TAKEN IS 8 HOURS.. MEANS 22:00HRS TO 06:00HRS IS NON WORKING HOURS ITS NOT TAKEN IN TO ACCOUNT....

START	END		PLACED FOR UNLOADING	UNLOADING COMPLETED	TIME TAKEN	ROUND OFF TO NEXT HIGHER HOURS
06:00​	22:00​		01-01-2022 14:00​	02-01-2022 08:00​	08:00​	08:00​
			01-01-2022 07:00​	01-01-2022 14:00​	06:00​	06:00​
			02-01-2022 10:10​	02-01-2022 19:00​	08:50​	09:00​
			02-01-2022 19:30​	03-01-2022 10:25​	09:55​	10:00​

I WANT FORMULA TO COLCULATE TIME TAKEN AND ROUNDING OFF TO NEXT HIGHER HOURS COLUMN.. PLEASE HELP..
ADVANCE THANKS

 

[BSALV]

there is never more then 1 day between unloading and unloading complete, for example starting on friday, complete on monday ??