Converting hours into days, hours & minutes

Hi

I have a problem that I hope you can help with.

For my work, I get paid in 'time in lieu' re: airline flight times for all time over 7.5 hours. These times are input in 24 hour format and can go 'past' midnight - into the next day. I need to know in days, hours & minutes, how much lieu time I have got.

Therefore in
A1 = start time flight out
B1 = end time flight out
A2 = start time flight back
B2 = end time flight back
C2 = total time =sum(B1-A1)+(B2-A2)-7.5 hours
D2 = d "days" h "hours" m "minutes"

My problem is two fold:
1. getting times 'past' midnight to add-up
2. getting answer in D2 to relate to 'actual' times and not decimal times

I know I am nearly there - but so far....

I have tried using:

=DAY(D2*3)&" days "&(D2*3-DAY(D2*3))*8&" hours "&MINUTE(D2)&" minutes"

But this is based on an 8 hour day - not 7.5 hours
I have tried converting times into decimals and formatting cells as [h]:mm, for 24 hour clock.

Hope all this makes sense and that you can help me

Regards
John

Hi Shg

Many thanks for such a quick reply.
It works - thank you!

I have attached a sample .xls
May I ask from my example, can you explain (B2>C2) part of the calculation - that returns False and (B10>C10) which returns True?

I am just interested in the use of that part of the calculation, as to return the correct answer.

Because in my example.xls B10 = 23:45 and C10 = 16:30 (ie a long haul flight over 2 separate days) = true

Whilst in the over example the answer is false - but the answer is still correct?

Many thanks

John