Formula to tell me how long something will take in minutes and hours

[tonywatsonhelp]

Hi Everyone,

I just want a formula to tell me how long something is going to take based on the number of items.

So in Cell K3 I have a number say 17

The formula needs to workout how many hours and minutes it will take to do all 17 items if each item takes 20 seconds

so basicly in English the formula would say Cell K3 = 17 , 17 * 20seconds = 340 seconds which is 5 minutes 40 seconds

Its ok to show it as 00:05:40 if that easier

 

[Scott T]

If you do not want to have 0 minutes then the second formula will only display the minutes if it is not zero.

Excel 2010
	K	L	M
3	17	items	2
4
5
6	5 Minutes 40 Seconds		40 Seconds
Sheet1

Cell Formulas
Range	Formula
K6	=INT((K3*20)/60)& " Minutes "&MOD((K3*20),60)&" Seconds"
M6	=IF(INT((M3*20)/60)=0,"",INT((M3*20)/60)& " Minutes ")&MOD((M3*20),60)&" Seconds"

 

[njimack]

=TIMEVALUE(INT(K3/3)&":"&((K3/3)-INT(K3/3))*60)
(formatted as hh:mm)

 

[kvsrinivasamurthy]

Formula

=TIME(INT(K3*20/3660),INT(K3*20/60),MOD(K3*20,60))

Format cells --> Custom --> [h]:mm:ss

 

[tonywatsonhelp]

Wow thank you everyone, overwhelmed with answers, this is great thank you all for your help.

Tony