Discussions

Expand all | Collapse all

Entering minutes and seconds, How?

  • 1.  Entering minutes and seconds, How?

    Posted 01-04-2020 15:44
    Hello, 

    I'm trying to establish a duration field and in it I would like to accurately represent minutes and seconds.

    I was able to do this by creating a Numeric field [Length] where users enter in a value like 4.12 ( 4 min 12 seconds ) and in the duration field I have this Formula : Minutes([Length]).

    With this - the duration field will have this value "4.12 mins". Thats ok, but I have 2 issues.

    1 - How can I get the value to be 4:12 mins

    2 - I noticed that sometimes the duration value will output to "4.309983333333" mins when 4.31 is entered in the Numeric field.

    I might be complicating things - the must be an easier way, but #2 is my bigger issue. I need to accurately represent minutes and seconds.

    Thanks!​

    ------------------------------
    Manny Pinheiro
    ------------------------------


  • 2.  RE: Entering minutes and seconds, How?

    Posted 01-04-2020 20:08
    Edited by Sharon Faust (QuickBaseJunkie.com) 01-04-2020 20:12
    Hi Many!

    If you want to represent 4.12 as 4:12, in your formula use the formula below. It separates the part before the decimal as the minutes and the part after as the seconds.
    Minutes(Int([Length]))+Seconds(Frac([Length])*100)

    Then make sure you have your units set to how you'd like them to look (smart units can cause weird results).


    Let me know if this solves your issue 👍😊


    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------



  • 3.  RE: Entering minutes and seconds, How?

    Posted 01-04-2020 21:20
    Thank You Sharon. This definitely pushed me in the right direction! 
    I really appreciate it.

    ------------------------------
    Manny Pinheiro
    ------------------------------



  • 4.  RE: Entering minutes and seconds, How?

    Posted 01-04-2020 22:49
    Manny,

    Where is your duration data coming from?   Are the Users entering the duration directly, are the entering a stop and start time which you are calculating the duration or perhaps a functioning start and stop process so that Quick Base holds it.

    Depending on your process an elegant solution can come out of it.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 5.  RE: Entering minutes and seconds, How?

    Posted 01-05-2020 15:47
    Great idea Don!

    I have a video on this type of function...


    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------