VBA to adjsut the UNIX time stamp with GMT/UTC offset to local time

Hi guys,

I'm having a big excel file with multiple sheets; some of them contain "Time interval" column with UNIX epoch time.
I'm running a macro to do the following:
-search thru all sheets and where it finds the "Time interval" column,
-applies the time conversion formula from UNIX to human time stamp, then
-deletes the UNIX time column and keeps only the human time

In sheet "General" $B20, I may have a GMT/UTC correction in minutes (e.q. -300 minutes > GMT -6hours).
If this cell (B20) is different than 0, can you please help me to modify the code by introducing a new column (let's say- "Local time") that adjusts the human time stamp with the GMT offset of -300 minutes?
Or, if much easier, just to update the formula with TIME function to add/subtract the offset of "General" sheet, B20, and add the output (human time stamp+GMT correction) in a single column.

Thank you in advance

The code:

Please Login or Register  to view this content.

divided the days to minutes and the formula works perfectly.

Thank you for your help and time.