How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jason Jones Your Own Question

Jason Jones
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
A new question is answered every 9 seconds

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