I have GMT Time column in XL sheet, I need to convert to CST in next column. How to do?
2007-12-05 04:13:44 · 3 answers · asked by redlotus72 2 in Science & Mathematics ➔ Mathematics
if I use =C2-TIME(6,0,0), for the 1:58:08 GMT I am not able to get the correct values.
1:58:08 ###############################################################################################################################################################################################################################################################
2007-12-06 03:52:12 · update #1
Converting the dates and times in column A from GMT (Greenwich Mean Time) to CST (Central Standard Time).
CST is 6 hours earlier than GMT.
Solution:
Use the TIME function as shown in the following formula:
=A2-TIME(6,0,0)
2007-12-05 04:22:58 · answer #1 · answered by ironduke8159 7 · 0⤊ 0⤋
CST is 6 hours behind GMT.
e.g. if it is 1200 or 12 noon GMT then it will be 0600 or 6am CST.
2007-12-05 12:24:11 · answer #2 · answered by Vaibhs >> 2 · 1⤊ 0⤋
whats the time difference? and whats the first cell reference of your GMT column (e.g. cell B3)?
2007-12-05 12:20:59 · answer #3 · answered by tsunamijon 4 · 0⤊ 0⤋