Blog

Calculating Indirect Activity Using Conversions

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

 

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

 

 

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

 

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.