Calculate the time elapsed between two dates based on business hrs

2006-03-06 Thread Botts, Tom
Has anyone tackled this before? I am trying to calculate the time elapsed between two dates based on business hrs. It will be used to build a report that tells us how long it takes to process an order. Basically only M-F 8am-6pm counts. Using datediff uses a 24hr calendar. I've looked

RE: Calculate the time elapsed between two dates based on business hrs

2006-03-06 Thread Snake
SQL also has it's own DateDif() fucntion. -Original Message- From: Botts, Tom [mailto:[EMAIL PROTECTED] Sent: 06 March 2006 18:29 To: CF-Talk Subject: Calculate the time elapsed between two dates based on business hrs Has anyone tackled this before? I am trying to calculate the time

Re: Calculate the time elapsed between two dates based on business hrs

2006-03-06 Thread Aaron Rouse
at 10AM I would do (3 * 10) + 4 + 2 That is a simplified explanation of what I did, hope it helps some. On 3/6/06, Botts, Tom [EMAIL PROTECTED] wrote: Has anyone tackled this before? I am trying to calculate the time elapsed between two dates based on business hrs. It will be used to build

Re: Calculate the time elapsed between two dates based on business hrs

2006-03-06 Thread rhymes with 'loud'
different holidays. [EMAIL PROTECTED] Doug :0) Has anyone tackled this before? I am trying to calculate the time elapsed between two dates based on business hrs. It will be used to build a report that tells us how long it takes to process an order. Basically only M-F 8am-6pm counts. Using datediff

RE: Calculate the time elapsed between two dates based on business hrs

2006-03-06 Thread Eric Roberts
elapsed between two dates based on business hrs Has anyone tackled this before? I am trying to calculate the time elapsed between two dates based on business hrs. It will be used to build a report that tells us how long it takes to process an order. Basically only M-F 8am-6pm counts. Using datediff