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
Yes.
Excelchat Expert
28/08/2018 - 06:18
Ok
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
OK.
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.