=WORKDAY time calculation

[Stanz838]

I am working on a worksheet to schedule machine time. I want to calculate the date and time a job will be completed based on a specific start date and time, then add job time, hours and minutes.
I am using the workday function, but it is rounding answer to nearest date. The formula is dropping the hours and minutes.

Cell V10 has the WORKDAY formula.

 

[awoohaw]

Try something like this in your worksheet:

Book1
	A	B	C	D
1	Start	End	Days	Time
2	2024-06-10 15:00	2024-06-14 07:00	4	16:00:00
3	2024-06-10 07:00	2024-06-14 15:00	5	08:00:00
Sheet2

Cell Formulas
Range	Formula
C2:C3	C2	=NETWORKDAYS.INTL(A2,B2,1)-((MOD(A2,1)>MOD(B2,1)))
D2:D3	D2	=MOD(B2-A2,1)

 

[Stanz838]

Thanks for the response. I don't think it will work for the application. I am using WORKDAY to calculate the end date, based on start date and number of hours and minutes to complete a job.

Thank you