Duration field

The Duration field in Baserow is specifically designed to store time durations measured in hours, minutes, seconds, or milliseconds.

In this section, we will explore the duration field in Baserow, ideal for tracking time-related data like task durations, call lengths, event lengths, video lengths, etc.

Overview

You can use this field to easily store information about the duration of projects, tasks, or meetings, and perform further manipulations with this data.

Add a duration field in Baserow

Add a duration field

To add a duration field,

  1. Click the plus sign + to the right of your existing fields.
  2. Select the duration type and name the field. You can add a unique field name in the customization menu.
  3. Select Duration field from the list.
  4. Click Create.

Duration format

You can set your preferred duration format from the drop-down options in the field configuration menu.

Baserow Formats for days

  • h:mm - This format is suitable for representing hours and minutes, for example, 1:23.
  • h:mm:ss - You can use this format to display hours, minutes, and seconds, like 1:23:40.
  • h:mm:ss.s - If you need to include deciseconds, this format allows you to represent hours, minutes, seconds, and deciseconds, such as 1:23:40.0.
  • h:mm:ss.ss - This format accommodates centiseconds, enabling you to display hours, minutes, seconds, and centiseconds, for example, 1:23:40.00.
  • h:mm:ss.sss - If you require even more precision, this format includes milliseconds, allowing you to show hours, minutes, seconds, and milliseconds, like 1:23:40.000.

Formats for days:

  • d h - This format is suitable for days and hours.
  • d h:mm - This format is suitable for days, hours, and minutes.
  • d h:mm:ss - This format is suitable for days, hours, minutes, and seconds.

Use formats displaying date intervals in days in formulas such as today() - field('date').

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.