Timesheet

Hi there,

Usually if I experiment with the formula long enough, I can figure it out, but this one is challenging me.
I inserted a formula that calculates correctly, if there is a value in the corresponding cells used, but unfortunately, my 'if' statement inbeaded in the formula is giving me an error message "#####" if the corresponding cell is a blank. The 'If' statement calculates on its own with no errors, but not when imbeaded in this formula. Following is the formula used and the attached file for your perusal if necessary.

Your assistance is very much appreciated.

=((INT((+IF((C12-B12),(C12-B12)," ")*24+3/60)*4))/4)/24

Martha

Formula works! Thanks for the suggestion, but in this department lunch is included in their hours worked, so it is not necessary for me to use those cells in the formula.

Have a Great Day!

MR

The IF function is redundant in your formula (and revised version). If it ever returned the false part, i.e. " " then you'd get an error because you are then trying to perform calculations on a text value [" "]

I'd suggest that something like this is neater and more logical:

=IF(COUNT(B11:C11)=2,FLOOR(C11-B11+"0:03","0:15"),"")

If B11 and C11 both contain times then you get a result, otherwise a blank. The result is the difference between the 2 times with 3 mins added and rounded down do the previous quarter hour

Your Good! It makes sense.

Thanks again

Martha