Forum Discussion
Solved
Convert to different time zone
Hello there I'm trying to convert a time column from Pacific to CET, but I keep getting #VALUE!. I suspect it has something to do with how the original time column is formatted, however I have alrea...
The column time_into_rr_hms contains text values. Check whether there are spaces after the "time" values, and if so, remove them.
The column time_into_rr_hms contains text values. Check whether there are spaces after the "time" values, and if so, remove them.
Yep, I figured it out just a moment ago. I solved it by pasting to Notepad and then back to Excel, removing the space at the beginning added by notepad. Thanks!