Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm trying to convert one time in a column from CST to another column to EST in excel
Solved by O. J. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 28/08/2018 - 06:17
Can you help me?
Excelchat Expert 28/08/2018 - 06:18
Hello and Welcome to Got It Pro!
User 28/08/2018 - 06:18
I just have one quick question that I cannot find on internet
Excelchat Expert 28/08/2018 - 06:18
Excelchat Expert 28/08/2018 - 06:18
User 28/08/2018 - 06:18
I have a spreadsheet that I DL and it's in CST. I want to convert that time B2 to C2 in est time
Excelchat Expert 28/08/2018 - 06:19
User 28/08/2018 - 06:19
=B2+(1/24) does not work
Excelchat Expert 28/08/2018 - 06:19
No. We need to use a time specific function.
User 28/08/2018 - 06:22
Ok...I'm lost
Excelchat Expert 28/08/2018 - 06:22
I am working on the formula now. One sec.
User 28/08/2018 - 06:22
Oh, ok
User 28/08/2018 - 06:23
I'm working as I'm chatting so plz bear with me
Excelchat Expert 28/08/2018 - 06:23
No worries.
Excelchat Expert 28/08/2018 - 06:25
that formula worked actually. What response did you receive when you used that formula?
User 28/08/2018 - 06:27
I kept getting #value# or #name#
User 28/08/2018 - 06:27
So,what i had was correct?
Excelchat Expert 28/08/2018 - 06:27
The time may be in a text format that needs to be converted to time format.
Excelchat Expert 28/08/2018 - 06:27
Can you paste and example for your file?
User 28/08/2018 - 06:28
Ah...ok I had them formatted in time
User 28/08/2018 - 06:28
Ok do the both have to be formatted in text or just the column I'm trying to change?
Excelchat Expert 28/08/2018 - 06:28
The column you are trying to change needs to be in time format.
User 28/08/2018 - 06:29
so my b2 formatted in txt and C2 in time?
Excelchat Expert 28/08/2018 - 06:29
Both in Time. B2 is HAS to be formatted in time for that function to work.
User 28/08/2018 - 06:30
Ok...thank you so very much. Your a life savere
Excelchat Expert 28/08/2018 - 06:31
My pleasure!
Excelchat Expert 28/08/2018 - 06:31
Is there anything else you want to know regarding this issue?
Excelchat Expert 28/08/2018 - 06:36
Please click the Done button and leave feedback if you have time. Thanks for using Got It Pro!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc