Hello,
My first post! I am trying to convert spreadsheet from UTC time and date to EST. My formulas for Column C is =MOD(B13-(5/24),1). But for the first 4 rows the time does not convert to 11/11/2016 as it should be. Another way I tried was =B13 -"05:00:00" which also converts the time but not the date. Can anyone help?
<colgroup><col><col><col></colgroup><tbody>
</tbody>
My first post! I am trying to convert spreadsheet from UTC time and date to EST. My formulas for Column C is =MOD(B13-(5/24),1). But for the first 4 rows the time does not convert to 11/11/2016 as it should be. Another way I tried was =B13 -"05:00:00" which also converts the time but not the date. Can anyone help?
Date | Time | EST |
11/12/2016 | 00:53:37 | 19:53:37 |
11/12/2016 | 00:54:09 | 19:54:09 |
11/12/2016 | 00:54:45 | 19:54:45 |
11/12/2016 | 00:57:01 | 19:57:01 |
11/12/2016 | 01:56:27 | 20:56:27 |
11/12/2016 | 02:20:43 | 21:20:43 |
11/12/2016 | 02:51:21 | 21:51:21 |
11/12/2016 | 09:10:54 | 04:10:54 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>