Hello....I'd appreciate some assistance (again). I have a 9-digit number that represents the GMT day and time (from the beginning of the year) that I'd like converted into the local day and time. So, the number, for example is 076003449 in cell A1. The first 3 digits represent how many days have passed from Jan 1 (076 = March 15, Jan 1 = 1 and this year was a leap year). The remaining digits represent GMT time (003449 = 12:34 AM GMT; I don't care about the seconds). And, I'd like the GMT time converted to Pacific time (12:34 AM = 4:34 PM Pacific the previous day - so, the local date now becomes 14 March). What I'd like to appear in cell B1, then, is 3/14/12 4:34 PM. The year is the current year; i.e., 2012. I can adjust for the new year. Many, many thanks in advance for your help!!!
Bookmarks