Can you please let me know how to convert time elapsed into days in sql server or any idea , Actually i want see avg days spent .    One more question is how the time elapsed it calculated will be consider your office working hour from 8am to  5pm and excluding weekend ,  if you can you please send me sql query .

Thank you,

Sri