SOLVED

Legal billing

Frequent Visitor

Looking for a formula that will yield legal billing hours (decimal) with a time input. If the minutes entered are 1-6 then the output is .1; if 7-12 then .2; if 13-18 then .3 and so on by six minute increments: 1-6 =.1; 7-12 = .2; 13-18 = .3; 19-24 = .4; 25-30 = .5; 31-36 = .6; 37-42 = .7; 43-48 = .8; 49-54 = .9, and 55-60 = 1.0.  I can subtract the time columns to give a total time worked, and then multiply that by 24 for minutes in decimal but after that get stuck with nesting so many OR's to try to match the 6 min increments. 

1 Reply
best response confirmed by David_Langer_2022 (Frequent Visitor)
Solution

Let's say the number of minutes is in C2 and down.

In D2, enter the formula

 

=CEILING(C2,6)/60

 

Fill down.

 

S0987.png