Time Clock Hour Rounding Active Report

Oct 23, 2006 0 Replies

What can I change in the time clock active report formula to get it to round the hours worked to the nearest quarter hours



.25 .50 .75 etc.



Begin Column FieldName = "Time" DrillDownFieldName = "" DrillDownReportName = "" StoreIDFieldName = "" Title = "StatPay100" VBDataType = vbDouble Formula = "cast(datediff(second, timein, timeout) as float) / 3600" ColHidden = False ColNotDisplayable = False FilterDisabled = True ColWidth = 1250 GroupMethod = groupmethodAverage ColFormat = "##.00" ColAlignment = flexAlignRightCenter End Column



Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required