• 100% Satisfaction Guarantee

Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 14398
Experience:  Over 10 years work experience.
30759776
Type Your Microsoft Office Question Here...
Jason Jones is online now

# I am trying to find the right formula following situation.

### Customer Question

I am trying to find the right formula for the following situation. We provide a service to where we are paid in :30 increments over the course of a treatment. There is a rule that states we cannot bill a :30 increment unless we have gone at least :16 into the next segment. Can you help me with a formula. I need to be able to determine
An example below:
Total treatment time 159 minutes.... 159/30 = 5.3 total segments. Knowing that the :16 minute threshold (0.5333333) so I know that I can only bill for 5 in this example
174 minutes= 5.8 increments = 6 total increments
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Jason Jones replied 1 year ago.

Hello,

I am the person that will be helping you today.

Will the time value be given in minutes or hours?

I will be standing by.

Thank you,
Jason

Expert:  Jason Jones replied 1 year ago.

I will assume that you are using minutes.

In the following example, the minute value will be in the A1 cell:

=QUOTIENT(A1,30)+IF(MOD(A1,30)>=16,1,0)

You can simply replace A1 in both areas in the above-mentioned formula with the actual cell reference in your document.

If you need anything else in the future, please let me know.

Thank you for your time today.

- Jason