Help

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

Solved
Jump to Solution
588 1
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: