View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Difference of time

Hi

I need to calculate the difference of time between to dates. Here is my
requirement

Column M2: 4/10/2009 12:45:00 PM
Column N2: 4/14/2009 8:11:00 AM

I would like to display the difference of this 2 columns in hh:mm format.
One important thing to note is we should not calculate weekends(Saturday and
Sunday)
And the business hours are from 9 AM to 6.30PM. So we have consider while
calculating the difference.

Can anyone please help me to resolve this.

Thanks in Advance
Raj