196
Questions / Re: Disc Duration
« on: June 12, 2024, 07:04:44 PM »
A new v4 formula to distinguish between discs longer/shorter than one hour.
It is also shorter, thanks to the use of modulos and downward roundings.
You'll need to have the Additional Tagging & Reporting Tools plugin installed (for $ge and $RoundDown).
Or, if you prefer the ... h ... min ... s format:
It is also shorter, thanks to the use of modulos and downward roundings.
You'll need to have the Additional Tagging & Reporting Tools plugin installed (for $ge and $RoundDown).
Code
$If($ge(<v3>,3600),$RoundDown($Div(<v3>,3600),0)":",)$Pad($RoundDown($Div($Mod(<v3>,3600),60),0),2)":"$Pad($Mod(<v3>,60),2)
Or, if you prefer the ... h ... min ... s format:
Code
$If($ge(<v3>,3600),$RoundDown($Div(<v3>,3600),0)" h ",)$RoundDown($Div($Mod(<v3>,3600),60),0)" min "$Mod(<v3>,60)" s"