Jump to content

Rounding Up By 15-Min Intervals


This topic is 5687 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Head ... ready to ... explode ...

Okay, my company bills clients in 15-minute increments. (If we work 8 minutes on the project, the customer gets billed for 15 minutes. If we work 17 minutes on the project, the customer gets billed for 30 minutes, and so on.)

I've created a Duration field that calculates (EndTime - StartTime) and tells me how long we *actually* worked on the project.

But the Cost field is set to calculate (Rate*Duration), which gives me a total billing amount that isn't right.

I've been pounding my head all day trying to figure out how to calculate this, and am just about ready to have a meltdown!

I started with this:

((( EndTime - StartTime)/3600)*4)*(Rate/4)

But I quickly discovered this only works if the difference of (EndTime - StartTime) works out to an increment of 900 seconds. Therefore, I need to always round (EndTime - StartTime) up to the next-highest 900-second increment.

Did anyone follow that? Or is there an easier way to do this that I'm not aware of?

As usual, thanks in advance for any advice.

Edited by Guest
Link to comment
Share on other sites

Div(Time; 900) * 900 + Case(Div(Time; 900) <> Time/900; 900)

Take the integer value of the time divided by 900. That's the number of seconds in a 15 minute increment (since time is tracked in seconds). This will leave with the number of whole 15 minute increments which is multiplied by 900 seconds to turn it back into time. If the time was already an exact multiple of 15 minutes, don't add 900 additional seconds since it is already correct.

Link to comment
Share on other sites

This topic is 5687 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.