Labor Tracking Dashboard - Elapsed Time on Op

Epicor ERP 10
1

Hi,
I am making a dashboard to be displayed on the shop floor. I am trying to calculate the time between operators logged into a job and the current time in my BAQ. TimeDiff throws an error that is it not an included function. Any ideas how to do this?

2 
(DATEDIFF(minute, DATEADD(minute, LaborDtl.ClockInMInute, '10/30/1953'), GETDATE()) / 60.00)
1 Like
3

Thank you so much. I did add +1 to the end to get the time to start at 0 instead of -1:00

4

if you want to consider change in clocking in dates

2 Likes