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

	A	B	C
1	Start time:	1/1/19 12:30
2
3	Corrected time	Time 1
4	1/1/19 12:30	0
5	1/1/19 13:30	3600
6	1/1/19 14:30	7200
7	1/1/19 15:30	10800
8	1/1/19 16:30	14400
9	1/1/19 17:30	18000

<tbody>
</tbody>

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