calculating multiple payment types

Basically I need to calculate total hours worked for a day.

Start and finish for lunch and start and finish for dinner. The problem is that after midnight the pay changes so I need to seperate the pre and post midnight hours.

I inserted this formula into F4 and F5
=IF(D4>24, (D4-24),0)

___a____b____c____d____e____f
1
2
3 __am_______pm_____pre24__post24
4 __12__16___18___22___10___-2
5 __11__14___18___26___9_____2


If there are hours after midnight(24) it works otherwise it subtracts the hours.

What am I doing wrong? tried without inside brackets as well.

The hours go past 24 because a single working day goes 'til 3am calculating total hours won't work unless 1am=25, 2am=26, etc.

Thank you for your help