Forum Discussion
maliknabhani
Jan 20, 2020Copper Contributor
converting timezone to local time at the same column
Hello, 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 ...
SergeiBaklan
Jan 20, 2020Diamond Contributor
Paste Special shall work:
1) Select B1 and Ctrl+C
2) Select range in column A (only select, nothing more)
3) Paste Special->Subtract
Result is
4) Apply DateTime format
maliknabhani
Jan 21, 2020Copper Contributor
Thank you, now is working by using 0.25.
- SergeiBaklanJan 21, 2020Diamond Contributor
maliknabhani , you are welcome