My existing formula in F5 (total time)
=IF(OR(D5="AL",D5="SICK",D5="PH"),8,IF(D5="","0",( ((E5-D5)+(E5<D5))*24)-0.5))

A5 = day of the week (monday etc)
B5 = date
D5 = start time (military time)
E5 = finish time (military time)
G5 = total overtime
H5 = time and a half
I5 = double time

My problem is:
on a weekend i have to pay a minimum of 3 hours so i need the total hours,
total overtime and time and a half column to show this.

many thanks
andy