text: i need the formula that rest .50 if the result is higher than 7 for ms excell? i'm working on a schedule spreadsheet that calculate the total of hours 8am to 10am = 2:00 i need the formula to deduct .50 if the result is over 7:00.  