M
mathjegna
I am working a drivers logbook formula for 80 hours in 7 days with a reset to
zero when a driver has a day off.
My problem is when the day off resets the hours to zero the next calculation
is giving me a negative number of hours.
I am using the formula =IF(F11>0,G10+F11-F4,0) where F11 is the current work
day G10 is the previous total hours and F4 is the hours from 7 days prior.
The problem is on day F12 if the hours worked are less than F5 the cell
records a negative number and then uses it in the following calculations.
I need to limit the time to positive only, how do I get the cell value to
remain zero if the formula provides a negative result?
zero when a driver has a day off.
My problem is when the day off resets the hours to zero the next calculation
is giving me a negative number of hours.
I am using the formula =IF(F11>0,G10+F11-F4,0) where F11 is the current work
day G10 is the previous total hours and F4 is the hours from 7 days prior.
The problem is on day F12 if the hours worked are less than F5 the cell
records a negative number and then uses it in the following calculations.
I need to limit the time to positive only, how do I get the cell value to
remain zero if the formula provides a negative result?