I know Excel can convert time forward i.e 1000 MST converted to GMT 1700. I can get some times to convert backwards but not all of them. I have tried this tip from the tip area Time Conversion

That workes well for the forward but not the reverse.

Please someone let me know if I am up a creek with out a paddle here.