Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Wrong result when I use HOUR()to calculate & display hours

Topic Labels: Formulas
Solved
Jump to Solution
1916 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Hans_Yu
4 - Data Explorer
4 - Data Explorer

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
image
image

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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:

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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:

This helped a lot! Thanks! :slightly_smiling_face: