Discussions

Expand all | Collapse all

Preserve 24-Hour Time Format in Formulae

  • 1.  Preserve 24-Hour Time Format in Formulae

    Posted 4 days ago
    I have a Formula-Text field that has a Time field inserted into it. The field itself is set to display a 24-hour format, but when put into the formula via the ToText() function, I get the standard format. So the way I see it, I have two options:

    1. Write a subformula like Right("00" & Hour([T]), 2) & ":" & Right("00" & Minute([T]), 2)

    or 2. Use a function that's not listed to preserve the format. Is there one available, or should I just go with writing out the function?

    ------------------------------
    Benjamin Golden
    ------------------------------


  • 2.  RE: Preserve 24-Hour Time Format in Formulae

    Posted 4 days ago
    I think that you will need to come up with your own text formula to preserve the 24 hour format.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



  • 3.  RE: Preserve 24-Hour Time Format in Formulae

    Posted 3 days ago
    Totally fine, just figured it'd be worth asking since I know QuickBase has a couple of hidden formula functions that someone might know about. I should've probably looked in Uservoice first since there is a suggestion with around 50 votes that asks for 24 hour time in formulas, but it'd be a good thing to see in the future. For now, I used the code snippet I wrote out in the OP and it works for what I need it for so no complaints here.

    ------------------------------
    Benjamin Golden
    ------------------------------