Convert Minutes into Units via Formula

Question

Hello, I am a new user and am attempting to convert minutes of contractual hours provided into units for the purpose of billable hours.  A sample of the data is below.  The third column "Billable Hours" is what I would like to achieve.  I'll have approximately one dozen conversions needed with the smallest increment being 0.25 and the largest being 4.0.  Can anyone assist with this type of formula? Thank you!

ServiceMinutes per MonthBillable HoursService 1601.0Service 22402.0Service 3901.5

SeanAdams · Answer

in addition to  @Emil_Kos 's response - if you always need to bill to the rounded up 1/4 hour then there's a trick to round the result to the nearest 1/4 hour.

* Multiply the minutes by 4
* Find how often 60 mins goes into the new total
* Take the ceiling of this (to round up)
* Divide the answer by 4 to get to rounded up .25 hours

roundUpBillabe.yxmd

Emil_Kos · Answer

Hi @rmalenda,

I think you need to use this formula:

[Minutes per Month]/60

but not sure why in row 2 you have the value of 4.

Hours to units.yxmd