Calculate end date and time with the help of duration and start date and time!

[MissDRPro]

Hi, I am working on a report that would be used to run maintenance. In this report, duration (it would take to run a script) would be in A column, start date and time (mm/dd/yyyy hh:mm in 24 hours format) would be in B column. I want to be able to calculate end date and time (mm/dd/yyyy hh:mm in 24 hours format) in Column C.

What formula should I use?

PS- I will be back with more questions because it is a complex report.

Thanks.

 

[ExceLoki]

what format will the duration be in?
ex for hour and half: 1:30, 1.5, 90, etc...

 

[awoohaw]

Depending on how you format and enter your data in column A, here are some different ways to do that:

Mr excel questions 55.xlsm
	A	B	C	D
1	Duration	Start	End
2	27:25	08/15/2023 00:00	08/16/2023 03:25	A2 Formatted as [hh]:mm (in this case 1 day 3 hours 25 minutes)
3	1.142361111	08/15/2023 00:00	08/16/2023 03:25	A3 formatted as numerical days and a numerical representtaion of hours and minutes (in this case 1 day 3 hours 25 minutes)
4	1.142361111	08/15/2023 00:00	08/16/2023 03:25	A3 formatted as numerical days and a numerical representtaion of hours and minutes (in this case 1 day 3 hours 25 minutes)
MissDRPro

Cell Formulas
Range	Formula
B2:B4	B2	=DATE(2023,8,15)
C2:C4	C2	=B2+A2
A4	A4	=1 + TIME(3,25,0)

 

[MissDRPro]

what format will the duration be in?
ex for hour and half: 1:30, 1.5, 90, etc...

in h/m 00:00

 

[MissDRPro]

Thank you!

Depending on how you format and enter your data in column A, here are some different ways to do that:

Mr excel questions 55.xlsm
	A	B	C	D
1	Duration	Start	End
2	27:25	08/15/2023 00:00	08/16/2023 03:25	A2 Formatted as [hh]:mm (in this case 1 day 3 hours 25 minutes)
3	1.142361111	08/15/2023 00:00	08/16/2023 03:25	A3 formatted as numerical days and a numerical representtaion of hours and minutes (in this case 1 day 3 hours 25 minutes)
4	1.142361111	08/15/2023 00:00	08/16/2023 03:25	A3 formatted as numerical days and a numerical representtaion of hours and minutes (in this case 1 day 3 hours 25 minutes)
MissDRPro

Cell Formulas
Range	Formula
B2:B4	B2	=DATE(2023,8,15)
C2:C4	C2	=B2+A2
A4	A4	=1 + TIME(3,25,0)

[/RANGE

Cell Formulas
Range	Formula