> It's easily possible in events! You just need a little math. If seconds is your number in seconds, floor(seconds / 60) is the minutes (divide by 60 and round down), and seconds % 60 is the seconds counter (modulo 60, ie. remainder after dividing by 60).
>
what if you have above 59 minutes and you want hours too?
hours: floor(seconds / 3600) (or: seconds / 60 / 60)
then use the result of seconds modulo 3600 for the rest of the calculations as seen above
totalseconds = 3980
hours = floor(totalseconds / 3600) = 1
totalseconds = totalseconds % 3600 = 380
minutes = floor(totalseconds / 60) = 6
seconds = totalseconds % 60 = 20
ZeroPad(hours, 2) & ":" & ZeroPad(minutes, 2) & ":" & ZeroPad(seconds, 2)
"01:06:20"
yeah, nice
EDIT: I forgot, in case someone asks for days too, just start with floor-dividing by 86400 (=3600 * 24) and use totalseconds % 86400 for the rest of the calculations.
Now try to find yourself the right value for weeks