My formula is Daily Rate / (Total Hours * 24)
Worked great until I hit a computation with 53 minutes.
Background: job pays $45, and can take up to 3 hours, but often takes less time. For the first time, the job only took 53 minutes. The formula returns an hourly rate of $0.08 instead of a little over $45. I need a formula that returns the correct results regardless of how long it takes to perform the job. Is there anything simpler than IF statements?
Worked great until I hit a computation with 53 minutes.
Background: job pays $45, and can take up to 3 hours, but often takes less time. For the first time, the job only took 53 minutes. The formula returns an hourly rate of $0.08 instead of a little over $45. I need a formula that returns the correct results regardless of how long it takes to perform the job. Is there anything simpler than IF statements?
