susanna123
Technical User
Attempting to round time to 2 decimal places. The result of formula gives value:
(58:59 when rounding to 2 decimal places, but when rounding to 4 - 57:59, the value is correct)
Formula is:
totext(abs({procRptIndProdUserModuleTime;1.TotalTime} / 3600),"00") & ":" &
totext(abs(remainder({procRptIndProdUserModuleTime;1.TotalTime},3600) / 60),"00") & ":" &
totext(abs(remainder(remainder({procRptIndProdUserModuleTime;1.TotalTime},3600),60)),"00");
Any help is appreciated.
Thks.
(58:59 when rounding to 2 decimal places, but when rounding to 4 - 57:59, the value is correct)
Formula is:
totext(abs({procRptIndProdUserModuleTime;1.TotalTime} / 3600),"00") & ":" &
totext(abs(remainder({procRptIndProdUserModuleTime;1.TotalTime},3600) / 60),"00") & ":" &
totext(abs(remainder(remainder({procRptIndProdUserModuleTime;1.TotalTime},3600),60)),"00");
Any help is appreciated.
Thks.