Trying to set up a spreadsheet for multiple users, that is relatively
foolproof.
Cell B13 has an hourly rate for a service.
Cells C13 and D13 have on- and off-site times for the service, both
formatted as hh:mm.
Cell E13 is the total on-site hours, formatted as a number, with the
following formula: =((D13-C13)-INT((D13-C13)))*24. This gives a value in
hours.
F13 is a variable numbers of hours charged for prep/travel time.
I want G13 to be the number of hours I bill for, with a minimum of 4 hours
on-site, and including the prep/travel time. Earlier, I asked for help on
how to do this, and got a few suggestions. None of them worked, but I
eventually got the following to work:
=IF(COUNT(C13:D13)=2,F13+MAX(E13,$B$35),0).
It all works brilliantly, with one small problem. As soon as I enter a
value in B13, I get an error message in G13 as follows:
The formula in this cell refers to a range that has additional numbers
adjacent to it.
I can tell the program to ignore the error, but I'd rather figure out a way
to not have the error appear at all.