Blog

Calculating Indirect Activity Using Conversions

Multiplied by 60 to get hours because the time displays in minutes by default.
Jo1

This was used to fix the date calculation for when someone worked passed midnight. Originally Epicor® wouldn’t add a day to the ClockOutDate.

Jo2

These next 2 fields are to make the option field that normally only shows the Date & Time, show just the Date instead. All that changes is the Data Type from (datetime) to date (compare to above screenshots) the “ClockInDate” & “ClockOutDate” will show the Date & Time.

Same calculations as before but different datatype

Jo3

Jo4

I used this Expression for the SSRS report: Got the GrandTotal time to calculate and display properly. There are 3600 seconds in 1 hour. TotalTime added the “Grand Total” of Seconds together. Then the Grand Total expression took that number and divided by 3600 to get the number of hours to display.

Jo10

Jo11

Jo12