Hi,
Can you please advice me how to calculate the below.., A
B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30 mins.
Now here imagine that i need to exclude the time taken from 02/03/2007
02:00:00 to 02/03/2007 03:30 and arrive the final hourly value as 24hrs and
00 mins!.

In Simple.,
The value of (B1-A1), to be again subtracted by the time between 02/03/2007
02:00:00 to 02/03/2007 03:30 (idle time) and make the final value to be 24hrs.

Can you please adivce me how to arrive to this formula.