Skip to main content
Question

Entering minutes and seconds, How?

  • January 4, 2020
  • 0 replies
  • 58 views
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
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
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
------------------------------
Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • January 5, 2020
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
------------------------------
Terms & ConditionsAccessibility statement