As Im still learning a lot€¦. I have a Query below to calculate rates per
hour:
Anything between 18:01 and 06:00 is one rate and anything between 00:00 and
06:00 is another rate

=IF((OR(G6="",E6="")),0,IF((G6<E6),((G6-E6)*24)+24,(G6-E6)*24))

Example Times
10:00 - 14:00 = 4 hours
10:00 - 18:00 = 8 hours
10:00 - 19:01 = 9.016666667 hours

Incorporate IF((OR formula above with this condition below
Then Subtract all that is equal to or less than 18:01 and the answer to
10:00-19:01 should be 1.016666667 hours

Example 2
10:00 - 20:00 = 10 should now = 2 hours

Another example
10:00 - 00:00 = 14 should now = 6 hours

Most important example as there are two different rates in this one.

00:00 - 10:00 = 10 should now be = 6 hours of one rate and 4 hours of
another rate
Each rate having its own cell.

Would some one like to help with this?