If statements

[Patrice71]

I need some help. I want any time that is over 6 hours to deduct a half hour for lunch and anything 6 hours or less to return just the time. I used this formula

=(IF(G7>6,G7-0.5),IF(G7<=6,G7-0)) but it's not working. What am I doing wrong???


Thanks,

Patrice

 

[TFRY]

Try this =(IF(G7>6,G7-0.5,G7-0))

 

[Patrice71]

Yeah! Thanks TFRY!!!