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
<tbody>
</tbody>
Thanks for the help
-R
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