calculating units

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am working on a sheet that would calculate times ie: 1000 - 1523. each unit we bill is in 15 min increments but we can bill for anything above 7 mins. i'm able to calculate the 15 min increments but cannot figure how to get the additional unit for any times that go above 8 minutes? would anyone have an idea how to do this. sure would save all of us time at the office instead of figuring it on paper. thanks for any help. d
 
I am not sure if you are holding the values as time or decimal. If it is
time, round it with

=ROUND(A1*4*24,0)/4/24

if it is decimal, round it with

=(ROUND(A1/15,0)*15)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

dlcamp said:
i am working on a sheet that would calculate times ie: 1000 - 1523. each
Click to expand...
unit we bill is in 15 min increments but we can bill for anything above 7
mins. i'm able to calculate the 15 min increments but cannot figure how to
get the additional unit for any times that go above 8 minutes? would anyone
have an idea how to do this. sure would save all of us time at the office
instead of figuring it on paper. thanks for any help. d
 
Back
Top