Column types
Duration
This is for spans of time, precise to the hundredth of an hour. When this is selected, there are settings in the Column Type inspector for the number of hours in a day, the number of hours in a week, and so on, so that you can calculate "real" time or "work" time. The time can be represented with full words like "weeks", "days", and "hours", or with abbreviations like "w", "d", and "h".