Entering minutes and seconds, How?
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 ...
Forum Discussion
QuickBaseJunkie
Qrew Legend
Qrew LegendHi 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.
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
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).
------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
- Thank You Sharon. This definitely pushed me in the right direction!
I really appreciate it.
------------------------------
Manny Pinheiro
------------------------------
