converting text to date/time

[hissonrr]

Good day all,

I am not great with date/time things in excel.

I have one column that is a text column that gives time intervals in seconds. I have a separate cell that gives a start time/date.

What I want to do is create another column that adds the seconds to the initial start time/date, so if the start time/date is 1/1/19 12:30 (military time please) and I have a cell that shows a text of 7200, I want the adjacent cell to show 1/1/19 14:30


What would I need to do to get my Column A4:A9 to calculate correctly?


example below

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD="align: right"]Start time:[/TD]
[TD]1/1/19 12:30[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Corrected time[/TD]
[TD]Time 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1/1/19 12:30[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1/1/19 13:30[/TD]
[TD]3600[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1/1/19 14:30[/TD]
[TD]7200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1/1/19 15:30[/TD]
[TD]10800[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1/1/19 16:30[/TD]
[TD]14400[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]1/1/19 17:30[/TD]
[TD]18000[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Thanks for the help

-R

 

[James_Latimer]

The only way i know how to do this would be to have =TIME(,,number of seconds) in the 'seconds' column.

e.g. 1/1/19 12:30 + =TIME(,,7200)
equates to 1/1/19 14:30

 

[steve the fish]

Try this in A4:

=$B$1+(B4/86400)

 

[hissonrr]

Worked perfect Steve

Thanks