Converting a range of times via a Macro

[peakymatt]

Hi Guys

Have a slight problem. Each week I receive a worsheet with a range of times along with a lot of other data. However the times in the sheet are all in local time. What I need is for the time to be in GMT.

I have been able to do this one line at a time, but what I need to do is when the sheet opens for all the times to convert automatically, via a macro or VBA or even by embedding a button in the sheet.

I have attached a sheet with some times and the formula I am currently using to convet the time by line.

Any help would be much appreciated.

Thanks

Matt

[JBeaucaire]

Give this a try, you'll have to adjust the range so that it points to the cells with all your times in it:

Please Login or Register  to view this content.

[Leith Ross]

Hello peakymatt,

You should update your profile to include where you are located on this big planet and which version or versions of Excel you are using. It would be a big help to everyone trying to answer your question, especially in this case.

This can be a bit complex to calculate correctly. Here are a few links that provide more detail about what is involved.

Time Zones And Daylight Savings Time

Convert Local Date/Time to GMT (Supports Daylight Saving Time/Summer Time)