Calculating time after midnight

Hi. I am trying to make a formula for a work timesheet.
By using the hours entered I want to work out how many hours after midnight have been worked (its a penalty rate).
I have tried using a simple "if end time>0" formula, but of course excel assumes all times are greater than zero.
I think it needs to incorporate the start time in the formula so that it knows midnight has been passed.
Any ideas?

How do you define "after midnight". Is that between midnight and a specific time, e.g. 0:00 to 06:00?

What is the range of possible start and end times?

basically start and end times a limitless. But assuming I start before midnight, 8:00 for example, then any period work after midnight is a penalty, be it 2 hours at 2:00, or 11 hours at 11:00.

If start time is in A2 and end time in B2 use this formula in C2

=(A2>B2)*B2

format C2 as h:mm

Thanks, thats great. How do I display it in a number, ie, 2:30 = 2.5 hours

=((A2>B2)*B2)*24

got it myself

Thanks for the help