Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
Solved
Jump to Solution
732 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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: