-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
gmt time
-
Power BI Gauge Visualization
Hi, I am using the gauge visualizations to show the sales versus target for the present day and another one for yesterday. The date is filtered via relative date. However I must wait for 08:00 in the morning for that specific visualization to update to the current local time. This is logical...- cyrilbrd
- Thread
- gmt time power bi utc
- Replies: 0
- Forum: Power Tools
-
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...- tuspilica
- Thread
- cell format format gmt time local time
- Replies: 5
- Forum: Excel Questions
-
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...- drd
- Thread
- gmt time local time serial values time time conversion
- Replies: 0
- Forum: Excel Questions
