Forum Discussion
@ Legal Billing in 6 minute increment
I need help creating a formula in Excel to be able to bill in 6-minute increments. For example: 1-6 minutes should be billed as .1; 7 to 12 minutes should be billed as .2; 13 to 18 minutes should ...
You're absolutely correct, I made a mistake on that one. It should .4.
I was wondering if you have a formula for this 6-minute increment billing.
Let's say your Total Minutes values are in C2 and down.
Enter the following formula in D2:
=CEILING(24*C2, 0.1)
If necessary, format D2 as General or as Number with 1 decimal place.
Fill down
It worked. Thanks so very much!