Answered

Timestamp appearing wrong

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm trying to get the date to correctly display in my Google Sheets but when I convert the current time it's basically displaying the time (PM) as an AM time. e.g. My command is run at 17:11 PM but it's showing 05:11 - How can I go about fixing this? I'm currently using the following for the time.

And I'm getting the below from the output - It appears to be 12 hours out but the destination time zone should be correct.

please note were currently on UTC(+1) due to BST but the output should be showing as 17:06:10 in the above

If there's any other ways to go about this I would be most appreciative as I was originally using the utcnow() within formatdatetime prior to switching over to this method due to wrong times being displayed. Any advice would be appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,798 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

The times that are shown appear to be correct. The following formatting examples may help:

utcNow('dd/MM/yyyy hh:mm:ss') ----> 10/08/2022 04:38:56

utcNow('dd/MM/yyyy hh:mm:ss tt') ----> 10/08/2022 04:36:01 PM

utcNow('dd/MM/yyyy HH:mm:ss') ----> 10/08/2022 16:36:30

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@ekarim2020 Hey, sorry for the long response getting back to you it's been a busy one! but thank you for your help, that HH:mm:ss helped sort the issue in no time at all and I've since made a mental note of this formatting for handling future timestamps as I know it'll be popping up a lot. Really appreciate your assistance on this.

Kind Regards,
Paul

Was this reply helpful? Yes No