I have a timesheet template that I want to add the total hours worked but have the result be at least 7.6. Our employees are paid 7.6 hours per day but only work 7.5, so they accrue their RDO. My formula I have so far is =((D6-B6)*24)-C6

for example:

Date Start Lunch Finish Total
14/05/15 (Thu) 9:00 AM 1 5:30 PM 7.50
15/05/15 (Fri) 9:00 AM 1 5:30 PM 7.50