pspkshah (5/29/2015)
thanks, I have just made slite change in that, in place of minute, I take hour.
You really do need to heed Sean's warning on this. Do the DATEDIFF as minutes and divide the result by 60.0 to get hours.
--Jeff Moden
Change is inevitable... Change for the better is not.