This is easy. Just subtract 1:30 from the final results. You may need to
format the cell in a different format to get the results your are looking for.

=B1-A1-1:30

The format Menu Number - Time has lots of formats.
You can enter time with hours a minutes into excel. Sunch as
1/3/07 22:30 and excel will automatically convert this time to excel time
format.

"Ajay" wrote:

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.