Calculate time to do a job

[Guest]

I need a formula or code to calculate the following:

I know that it takes 2 hours to complete 25 questions. I am trying to
calculate how long it takes to do 1 question, then multiply that by however
many questions and the result should be to the nearest 15 minutes in decimal
format.

Example: If 1 question is 4.8 minutes: then 10 questions would be 48
minutes. I want it to round to 45 minutes and give the result .75.....If 5
quesitons is 24 minutes, then I want it to round to .50 minutes.

 

[Guest]

A1="Total time"
B1="Total Questions"
C1="per qestion time"
D1="however many questions"
E1="rounded time"

A2=02:00:00
B2=25
C2=+A2/B2
D2=10
E2=MROUND(MINUTE(C2*D2),15)/60
which calculates out to .75

A3=00:24:00
B3=5
C3=+A3/B3
D3=5
E3=MROUND(MINUTE(C3*D3),15)/60
which calculates out to .50

--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.