Time calculation

Hi, this is the scenario I'm trying to solve.

Between the hours of 06:00 - 19:00 we charge at rate 1.
After 19:00 and before 06:00 we charge at rate 2.

I'm creating a time calculator where you enter the start time and end time and it automatically calculates how many hours of which rate we should charge.

I've managed to work everything else out, but am struggling when the end time goes past midnight (or rather more specifically, it works for any time between 24:00 - 24:59, but does not like from 01:00 onwards).

So what I need it to work out is how many hours past 19:00. Can anyone help please? :-)

Thanks for that. I think though that you're trying to solve the whole calculation for me? I've managed to (probably rather clumsily!) calculate the number of hours if the start time is before 06:00, and the number of hours between 06:00 - 19:00. So all I need is the formula that says "if the end time is after 19:00, the number of hours from that time to end time" regardless if it goes past midnight.

I can't tell from what you've written, whether you're just addressing what I need or everything else too? :-)