Hi Vara,
thanks for the formula.
I just checked with few. The result as shown below:
10/3/2010 14:06 10/4/2010 3:39 -10.44
10/21/2010 11:06 10/21/2010 11:09 0.051666667
10/10/2010 5:50 10/14/2010 8:15 27.26111111
10/11/2010 6:15 10/11/2010 6:20...
Hi All,
Need formula to calculate the total time between two dates
Eg:
A1=11/19/2010 7:34 AM
B1=11/23/2010 6:50 PM
Want to calculate total time between A1 and B1.
It should exclude weekends
It should take time only from morning 08:00 AM to 05:00 PM(weekdays).
Let me know how can i...