I am trying to work on a clock face that deals with GMT. If the GMT offset is an even hour, everything works fin. However, I cannot figure out how to check if it off by 30 minutes. Yes. I can divide the number by 3600 to get the hours. I have it formatted to return 1 decimal place (which should always be a 0 or 5). How do I check that number to see if it is a zero or half so that I can act on it? Can someone either answer or point me to a sample where this is successfully done?
Thanks,
Jeff