Wrong result when I use HOUR（）to calculate & display hours

Question

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

ScottWorld · Accepted Answer

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:              Airtable        Time Zones: Working with multiple different time zones in Airtable - Airtable...  This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in...                              SOLUTION: Working with multiple different time zones in Airtable Dates and timezones        I’ve created a sample base & accompanying training video to solve the dilemma of working with multiple different time zones in Airtable. This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in their own local time zone. My sample base gives a properly-converted local time for any event — based on the event’s original date, time, and time zone. This base could also be adapted to solve the probl…

Hans_Yu · Answer

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:              Airtable        Time Zones: Working with multiple different time zones in Airtable - Airtable...  This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in...                              SOLUTION: Working with multiple different time zones in Airtable Dates and timezones        I’ve created a sample base & accompanying training video to solve the dilemma of working with multiple different time zones in Airtable. This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in their own local time zone. My sample base gives a properly-converted local time for any event — based on the event’s original date, time, and time zone. This base could also be adapted to solve the probl…  This helped a lot!  Thanks!  :slightly_smiling_face:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded