Forum Discussion
Solved
Legal billing
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 ...
Let's say the number of minutes is in C2 and down.
In D2, enter the formula
=CEILING(C2,6)/60
Fill down.
Let's say the number of minutes is in C2 and down.
In D2, enter the formula
=CEILING(C2,6)/60
Fill down.