Excell to calculate time.

[webezine]

Hey

Wanted an excel genius to help with this as its a bit beyound me.

In my job I have to calculate my stats to provide to a manager.
This require me to caluclate the time its taken me to compelte a piece of work.

I enter the time I received the work in ie in A2 i put 17:00 and time I finished it ie b2 10:11

Now the complicated thig is I want excel to do the calculation for me so that it doesnt count hours outside the working day (8am to 6pm) so it will ignore hours between 6pm and 8am.
I would imagine it would be done with If statements but I cant get it to work,

Any thoughts?

[daddylonglegs]

I'm assuming that the times will be on the same day? If B2 is later than A2 then you'd have to enter that as 22:11 or 10:11 PM.....then try this formula for business hours

=MIN(B2,"18:00")-MAX(A2,"8:00")

format result cell as h:mm