Time Card

I'm trying to get this time card to calculate the number of hours worked between midnight and 7am. Its under differential pay. The formula I inherited used to work, but I had to update the sheet recently to include the date in the input log tab for in/out times and this seems to have void the formula I inherited. Any ideas on how to fix this?

=F12+D12-((C12>E12)*MEDIAN(0,E12-7/24,24/24)+MAX(0,MIN(24/24,E12+(C12>E12))-MAX(7/24,C12)))*24

I've attached the sheet I'm working with so the formula makes sense.