Dec 10 2021 02:20 PM - edited Dec 10 2021 02:20 PM
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.
Dec 10 2021 02:41 PM - edited Dec 10 2021 02:43 PM
SolutionLet's say the number of minutes is in C2 and down.
In D2, enter the formula
=CEILING(C2,6)/60
Fill down.
Dec 10 2021 02:41 PM - edited Dec 10 2021 02:43 PM
SolutionLet's say the number of minutes is in C2 and down.
In D2, enter the formula
=CEILING(C2,6)/60
Fill down.