@ Legal Billing in 6 minute increment

[afsamawi]

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.

Start	End	Total Minutes	Time
1:00 PM	1:10 PM	0:10	0.2
1:53 PM	2:15 PM	0:22	0.4

[#2]

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

[#3]

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

[#4]

@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

[#5]

@Hans Vogelaar 

It worked. Thanks so very much!