Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Time Elapsed between dates excluding weekends

Author  Topic 

ttakundwa
Starting Member

5 Posts

Posted - 2007-06-13 : 04:02:56
hie,
i am developing a Call logging system, and i need to calculate the
downtime; i.e. time call is logged to time call is resolved. the
function should be such that it only calculates during working hours,
i.e. Moday to Friday from 8am to 5pm.
thanks,

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-13 : 04:11:00
make use of the F_TABLE_DATE here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519


KH

Go to Top of Page
   

- Advertisement -