Converting Greenwich Mean Time

RudeRam

Board Regular
Joined
Apr 2, 2004
Messages
73
I using thefollowing formula : A1+7/24 to convert Greenwich Mean Time to my local time zone (MST). It works great for times from 0701-0000, but from 0001-0700 I get the ###### mask. I am confused as to why it work for 17 hours but not the remaining 7 hours. The cells are formatted as hhmm.

Thanks in advance for any help
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
Maybe it is a problem when A1 + 7/24 is bigger than 1 day.

How about
=If( (A1+7/24) > 1, 1 -(A1+7/24), A1 + 7/24)
 

RudeRam

Board Regular
Joined
Apr 2, 2004
Messages
73
CORRECTION TO ORGINAL POST

Formula shourd be A1-7/24 not as it is written in the post,

PA HS I tried your suggestion and that works for the hours I am having trouble with when used for the other hours it converts the time forward vise backwards. Thank you for that input I will sit down and monkey with this some more

Thanks again to all
 

RudeRam

Board Regular
Joined
Apr 2, 2004
Messages
73
Brian,

Thank you again you always know where to find the answers that alude me
 

Forum statistics

Threads
1,147,847
Messages
5,743,522
Members
423,801
Latest member
paulj4177

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top