SOLVED

Convert to different time zone

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3173351%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EConvert%20to%20different%20time%20zone%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3173351%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHello%20there%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20convert%20a%20time%20column%20from%20Pacific%20to%20CET%2C%20but%20I%20keep%20getting%20%23VALUE!.%20I%20suspect%20it%20has%20something%20to%20do%20with%20how%20the%20original%20time%20column%20is%20formatted%2C%20however%20I%20have%20already%20tried%20General%20formatting%20and%20several%20different%20time%20formats%2C%20and%20I%20keep%20getting%20the%20error.%20Any%20suggestions%3F%20In%20the%20screenshot%2C%20both%20columns%20are%20in%20General%20format%2C%20but%20I've%20already%20tried%20all%20others.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348733iC5FCAC9B40255585%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Ber93_0-1645021851793.png%22%20alt%3D%22%5C%26quot%3BBer93_0-1645021851793.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20what%20the%20original%20time%20cell%20contains%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F348734i3AF41BC48A1E4792%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Ber93_1-1645021910256.png%22%20alt%3D%22%5C%26quot%3BBer93_1-1645021910256.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3173351%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

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.

Ber93_0-1645021851793.png

This is what the original time cell contains

Ber93_1-1645021910256.png

 

 

2 Replies
best response confirmed by Ber93 (Occasional Contributor)
Solution

@Ber93 

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!