Show each hour worked in shift over midnight

I want to return "1" for each hour worked in a shift. I can get this to work before midnight:
Shift Start Time A2
Shift Finish Time B2
Times 6:00 - 5:00 C1:Z1
=if(AND(C$1>=$A2,C$1<$B2),1," ") returns "1" in Row 2 for each hour worked.
I am stumped as to the formula required to return "1" for a shift that spans midnight

Any help appreciated.

When i've worked with times, the only way to get midnight to work is by formatting the cells as [hh]:mm.. 25:00 = 1am ~ 30;00 = 6am

Then one - the other should work..

Hope this is what you are after

Any chance we could see the workbook?
Makes it FAR easier to help out.

BSB

No need to see the sheet, the post gives adequate information.

Try this one

=IF($B2>$A2,IF(AND(C$1>=$A2,C$1<$B2),1,""),IF(OR(C$1>=$A2,C$1<$B2),1,""))

Many thanks jason b.75, a perfect solution. I had almost got there in an earlier iteration but missed the subtlety of the "OR".

Thanks to others for your suggestions.