
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2020 06:50 AM
Hi everyone,
I’m trying to use formular HOUR()to display my Time as a number. But I keep getting wrong result.
Normally, if the time is 18:30, the number from HOUR() should be 18, but I get 9.0.
Could someone help me to have a look if my formular is wrong?
Cheers
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2020 07:53 AM
Welcome to the community, @Hans_Yu!
This is a time zone issue. For your “Finish Time” field, you will probably want to turn on the formatting option to show the same time (GMT) for all users.
For a more advanced deep dive into time zones, you can check out my training video & sample base located at either of these 2 locations:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2020 07:53 AM
Welcome to the community, @Hans_Yu!
This is a time zone issue. For your “Finish Time” field, you will probably want to turn on the formatting option to show the same time (GMT) for all users.
For a more advanced deep dive into time zones, you can check out my training video & sample base located at either of these 2 locations:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 18, 2020 08:34 AM
This helped a lot! Thanks! :slightly_smiling_face:
