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 ...
afsamawi Why should 22 minutes become 0.3? It falls in the range of 19 to 24 minutes, so it should be 0.4 based on "the 6 minute rule".
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!
