With some…alot of help from AI and multiple iterations I was able to get a formula to work.
CASE
WHEN LaborDtl.ActiveTrans = 0 THEN
CAST(LaborDtl.LaborHrs AS decimal(9,4))
WHEN LaborDtl.ClockInMinute IS NULL THEN
NULL
ELSE
CAST(
(
DATEDIFF(
minute,
‘10/30/1953’,
DATEADD(second, Constants.CurrentTime, Constants.Today)
)
- LaborDtl.ClockInMinute
) / 60.0
AS decimal(9,4)
)
END
This is giving me the act labor hours spent on starting from clock in time.