converting timezone to local time at the same column

Question

Hello,&nbsp;I have a data logged file, recoding data by minutes of one month, and I need to covert the timezone in the CU column to my local timezone (-6/24) but I need to do this in the same column CU by one click.I have tried a special past to subtract the value&nbsp;(-6/24) but didn't work out. &nbsp;&nbsp;Changing the timezone will change the date and time.&nbsp;

sergeibaklan · Answer

maliknabhani&nbsp;
Paste Special shall work:

1) Select B1 and Ctrl+C
2) Select range in column A (only select, nothing more)
3) Paste Special-&gt;Subtract
Result is

4) Apply DateTime format

maliknabhani · Answer

Thank you, now is working by using 0.25.&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

maliknabhani&nbsp;, you are welcome

Forum Discussion

converting timezone to local time at the same column

3 Replies

Resources