How can I add a time field in 24hrs clock?

Hilbert Kok
Hilbert Kok ✭✭✭✭✭
edited 09/22/23 in Formulas and Functions

Does anyone ahs experience how to add a column that has a time field in it. I have now done it with 3 columns, one drop down 1 to 24 hours, on with 1 to 60 minutes and one combinding those two ito one filed with XX:YY. This is very confusing for the user. I rather want them to select the time from a specific time field.


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 02/15/22

    Hi @Hilbert Kok

    I hope you're well and safe!

    Unfortunately, Smartsheet doesn't have a Time Type Column, so it's not possible now, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    Here's a possible workaround or workarounds

    • Another option would be that they enter the time as 11:04 or 1104, and then you can convert it if needed, and you could also add a message if they are not entering it correctly.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Chris Newton

    At the risk of being a troll... I've got to ask the question that I don't being seen on this same question over and over...

    Did you guys not think that project management software, especially software that is paid accounts... would want to track time? I mean, the software is able to track dates. You actively promote project management as a key use for the software. I have seen people asking for this functionality for 2 years. This is an extremely function in Excel and Google Sheets.

    Let's get this function taken care of.

  • Amanda Fulbright
    Amanda Fulbright ✭✭✭✭

    @Chris Newton I logged a feature request for this today. I searched the community and found so many threads asking for this basic functionality going back to 2020. I don't have any real hope that it will be added. I don't understand how something so basic is missing, requested repeatedly, and still just ignored by the development team. I hope somebody is reading these comments and gets this one moving!

  • Brandon Mears

    Adding my voice to the chorus. We badly need this feature for Smartsheet to continue to be useful for us. I agree that it seems odd that it wasn't included from the beginning. I'm sure there is a reason, but I can't think of one. I also submitted a feature request.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!