I need help

[Jitkum1982]

I have start date and time. Then enter. Value in day /h column then show end date and time[ but easily count date with workdays formula But time accurate didn’t show ]

Start date and time 16-03-2020
Working hours 9:00am to 18:00 pm
Columm. D/h Then start my work 16-03-2020 14:00 pm. Add. 6 hours in then show next date 17-03-2020 10:00 am

 

[ExcelGzh]

If you set your data up as per the below table that should solve your problem. Column D is a helper column that saves the formula in column E being hugely complex. By the way, you would finish your task at 11:00am the next day not 10:00am

Book2
	A	B	C	D	E
1	Start Work	9:00
2	End Work	18:00
3	Duration	9:00
4
5		Start	Duration
6	Start	16/03/2020 14:00	6:00	1.222222	17/03/2020 11:00
Sheet1

Cell Formulas
Range	Formula
B3	B3	=B2-B1
D6	D6	=((TIME(HOUR(B6),MINUTE(B6),0)-XLOOKUP(TIME(HOUR(B6),MINUTE(B6),0),$B$1:$B$2,$B$1:$B$2,,-1))/$B$3)+C6/$B$3
E6	E6	=DATE(YEAR(B6),MONTH(B6),DAY(B6))+INT(D6)+$B$1+(D6-INT(D6))*$B$3