Forum Discussion

afsamawi's avatar
afsamawi
Copper Contributor
Sep 30, 2022

@ 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 be billed as .3 and so on.

I am having a problem creating the formula in Excel to come up with .1, .2, .3, etc.

In the example below, the entry with a total of 22 minutes, should be billed as .3, not .4. Please help.

StartEndTotal MinutesTime
1:00 PM1:10 PM0:100.2
1:53 PM2:15 PM0:220.4
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Oct 01, 2022

    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".

    • afsamawi's avatar
      afsamawi
      Copper Contributor
      Oct 01, 2022

      Riny_van_Eekelen 

      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.

       

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 01, 2022

        afsamawi 

        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

Resources