TIME FORMAT is wrong

[Kemal1973]

I have a column named "time remaining (hour) in my table but when it is less than one hour it doesn’t display “hh” and only shows mm:ss

[Himaladin]

Because of your calculation method, it will be a duration instead of a date-time.

Guide: Mastering Dates & Times

The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here are a few tips: Writing dates Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source. Relations Anytime you create a relation with a date, convert the date to either a string (template column) or a number (…