Excel 2007 : Time Formula

thats fantastic! thankyou

One problem I found is if I arrive home before 16:00 it shows a negative value which in turn is deducted from the months total, can I have negative values show and caculated as 0?
Now, at the risk of being cheeky (which I can assure you thats not what I want to be ) at the other end of the scale can I adapt this to if I drive before 07:30 but arrive after 07:30, it will only calculate up till 07:30.

Is it possible to explain the formula in simple terms, I find it intresting but dont understand it.

Thanks Again
Alan

I couldnt get it work, I changed all the comma's to semi colons (I have excel in Swedish) but still it wouldnt work. Maybe, if you have time, you could look at the attachment and tell me where I am going wrong.

Thanks for all your help
Alan

EDIT
Forgot to change IF to OM
That works great.

Now with the morning journey, its reversed so that I count everthing before 07:30 but nothing after.

I just cant get the formula in reverse
This time I would like where a1 is the start time (Before 07:30) and B1 is the end time, as before but only calculated up till 07:30
eg a1 = 07:00 and b1 = 07:35, it will give an answer of 30 mins But I just cant get it.
Please can you help again.
Alan

EDIT

GOT IT!

Thanks darkyam for all your help.

Regards
Alan