Glide HomepageOpen Glide

Getting Started

Quickstart
Intro to Layout
Intro to the Data Editor
Data to Layout
Intro to Actions
Intro to Workflows
App Settings
Templates

Essentials

Data Sources
Basic Columns
Components
Security and User Data
Users
Publishing and Sharing

Automation

Actions
AI
Computed Columns
Integrations
Workflows
View API Docs

Use Cases

Forms
Images in Glide
Conditions, Filtering, and Visibility
Duplicating Apps

Reference

Account
User Experience
Values
  • Computed Columns
  • Format Duration

Format Duration

Format a duration from seconds into hh:mm:ss.

If your app displays durations in seconds, you can use the Format Duration computed column to convert the duration into hours, minutes, and seconds.

Creating a Format Duration Column

Creating a Format Duration Column

  1. In the Data Editor, open the table you want to edit.

  2. Add a new column by clicking the plus (+) symbol to the right of the table.

    • New columns added with the plus button will always appear on the right of the table. If you'd like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose Add column right. You can also click and drag columns to rearrange them.

  3. Name the column.

  4. For Type, search for Format Duration or navigate to Computed → Experimental → Date & Time → Format Duration.

  5. For Seconds, enter a custom value or select a column from your data source that contains the value for the number of seconds you’d like to format.

  6. For Format, enter a custom value, or select a column from your data source to use as the format style.

Have a question about Format Duration? Ask the Glide community.
Need more help? Hire an Expert.

Updated more than a week ago

Previous

Experimental Code Column

Next

Generate Image

Was this article helpful?
Exit Preview Mode