Sum for time on task calculations

[Caesium]

Excel Gurus, I need your help!

This is probably very simple but I cannot find the answer of the life of me.

I want to create a time on task calculator where you can put in a multiple of a predefined task and it will work out the time it should take to complete that task, for example:

I define that picking 5 apples takes 2 minutes. I put in 45 apples picked and the formula states the time taken, in HH:MM and displays in another cell

I also need it to "round up" in case someone enters 7 apples instead of multiples of 5.

Hopefully this makes sense.

 

[Asbestos_Jen]

Try this:

Book1
	A	B	C	D	E
1	Task	Time (hh:mm)/ task unit	Unit	Tasks completed	Time on task
2	Pick apples	00:02	5	17	00:08
3	Pick cherries	00:04	10	23	00:12
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=B2/C2*CEILING(D2,C2)

 

[Caesium]

Absolute legend. I cannot thank you enough!

 

[Asbestos_Jen]

Glad to have helped, and thank you for the feedback.