MS Excel CST MST and PST
Posted on 2014-04-24
I am embarrassed to ask this question, yet after trying to find the solution, I thought it be best to ask. The problem is very simple. Using Excel, I want to have three columns; CST, MST, and PST. The solution is that MST will be the reference time (Mountain Std Time) in military time (0-24), CST is Central Std Time and PST is Pacific Std Time.
Therefore the center column will be MST, the column to the left will be CST=MST+1 hour.
And PST=MST - 1 hour. I do not need the date. I played with TIME() and TIMEVALUE() and "without going off and reading about it" I could not get it to work.