Converting Minutes To Hours In The Results

When converting minutes to hours “Floor It” in the results.  For example

Holiday Example:

if (Holiday_Minutes !=’0’) {Floor(Holiday_Minutes/60) + ’:’ + Substr (‘0’ + Mod (Holiday_Minutes, 60), Length (Mod(Holdiay_Minutes,60)))} else {null}

Leave Balance Example:

If (Leave_Balance_end_of_FY01 >’0’) {Floor(Leave_Balance_end_of_FY01/60) + ‘:’ + Substr (‘0’ + Mod (Leave_Balance_end_of_FY01, 60), Length (Mod(Leave_Balance_end_of_FY01,60)))} else {null}

Last updated: October 15, 2013

Last updated: October 15, 2013