Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
I need a script that converts calculated minutes to hours:minutes format
eg. 96 minutes / 60 = 1.6 hours, which i want it to then convert to 1:36 (Hour:Minutes)
any help would be great. Thanks
Give this a go....
// form1.page1.subform1.formattedTime::calculate - (FormCalc, client)
var hours = Floor(form1.page1.subform1.timeInMinutes.rawValue / 60)
var minutes = Mod(form1.page1.subform1.timeInMinutes.rawValue,60)
if (minutes < 10) then
minutes = Concat("0",minutes)
$.rawValue = Concat(hours,":",minutes)