IF Function

[Frank Fisher]

I'm working on time schedule worksheet. I would like to subtract 30 minutes
if the hours for that day is 6 or greater. then I would like to subtract 60
minutes if the hours for that is 8 or greater. How do I do this in one cell
with formula in to calculate the total time? Can it be done with the "IF"
function? Thanks

 

[Frank Kabel]

Hi
how have you stored your time values?. As Excel time values (format hh:mm)?