I am trying to convert a DateTimeUTC value to CST. Here is an example of the DateTimeUTC Value that I am trying to convert:
DateTimeUTC
1258119969
I have had some success with this formula - =(((D:D/60)/60)/24)+DATE(1970,1,1) (where D equals the cell with the UTC time in it) but it doesn't get me to CST - I can't figure out how to subtract the six hours needed.
DateTimeUTC Converted Time
1258119980 11/13/09 1:46 PM
1258120491 11/13/09 1:54 PM
Any thoughts?