Feb 16 2022 06:32 AM
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 already tried General formatting and several different time formats, and I keep getting the error. Any suggestions? In the screenshot, both columns are in General format, but I've already tried all others.
This is what the original time cell contains
Feb 16 2022 06:57 AM
SolutionThe column time_into_rr_hms contains text values. Check whether there are spaces after the "time" values, and if so, remove them.
Feb 16 2022 06:59 AM
Feb 16 2022 06:57 AM
SolutionThe column time_into_rr_hms contains text values. Check whether there are spaces after the "time" values, and if so, remove them.