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?
(DATEDIFF(minute, DATEADD(minute, LaborDtl.ClockInMInute, '10/30/1953'), GETDATE()) / 60.00)
Thank you so much. I did add +1 to the end to get the time to start at 0 instead of -1:00
if you want to consider change in clocking in dates