gmt time

  1. T

    GMT/UTC to local time conversion

    Hi guys, I'm trying to convert from GMT time to local time. I have the a column where my data has the format: 19-01-2019,07:20:23 I applied the formula: =A2-(5/24) to calculate the local time but i got the error: There's something wrong with the way your formula is typed. Or, there's...
  2. D

    Excel Macro Local GMT Display

    I am part the way through an assignment. I have been able to create macro to give me now time (thanks to post by VoG in Feb 07) but also need to display current GMT to finish building global time converter. This is the closest I have found (below - from...

Some videos you may like

This Week's Hot Topics