1 of 1 people found this helpful
DATEDIFF will give you a whole number, so if you pass it "hour", it will round that hour. If you want decimal values, then change it to the following:
DATEDIFF('minute',[Asset Checked In At],[Status Changed To Hold Auth At])/60
This should give you a decimal value, measured in hours. Does that make sense?
ah, ok. that is what I needed! Thank you for your help!@
Great. If you wouldn't mind, please mark the answer as the "correct answer" so that we can close this thread and others with similar questions in the future may learn from it. Thanks!!