help for a IF argument...

**Lisachocfrog** · 10-17-2012, 06:15 PM

thanks, yes that works nicely, however, just to complicate matters in this timesheet the time to be paid is for 7 hrs 36mins, regardless of the hours worked. the "accrued TOIL" is only calculated after the total hours worked is over 8 hrs, so somehow I need to show this formula to calculate the difference between hours worked & to be paid minus 24 mins only when the total hours worked is over 8 hours, the way i am doing this the error says I have too many functions...so there is a bit of swearing....

**:) Sixthsense :)** · 10-18-2012, 12:57 AM

Try this in K10 cell

Formula:

=IF(TIME(HOUR($J10),MINUTE($J10),SECOND($J10))>TIME(7,36,0),TIME(7,36,0),$J10)

Try this in M10 cell

Formula:

=IF(TIME(HOUR($J10),MINUTE($J10),SECOND($J10))>TIME(8,0,0),$J10-TIME(8,0,0),TIME(0,0,0))

Refer the attached file for details.

Hope that helps!

**Lisachocfrog** · 10-18-2012, 01:55 AM

more swearing, good swearing......thanks so much this works perfectly....doin' a little dance now

would love to know more about how to work this out myself, new to excel workings & keen to learn how to do it (self taught) properly

again, thank you thankyou