i have a formula that calculates the difference between two dates and tells me the hours but instead of giving round in hours, i need hours to be displayed in decimal format. Can someone direct me to the right formula to use?
Delivered = l.ArriveDateTime ,
Weighed = t.TareWeighedDateTime ,
Processed = l.ProcessedDateTime ,
'Wait Time' = DATEDIFF(SECOND, l.ArriveDateTime, l.ProcessedDateTime)/3600,