Formula Help

[Hardik_Gadhavana]

A1=14,Then Result B1=01:10 if A1 is multiply by 5 Minute then B1 is in HH:MM Formet, what is formula for B1?

[#2]

Hello @Hardik_Gadhavana,

This is most certainly not the most efficient formula but it will do the trick. If A1=14 and B1=A1*5, then C1 has the formula:

=IF(ROUNDDOWN(B1/60,0)<10,"0"&ROUNDDOWN(B1/60,0),ROUNDDOWN(B1/60,0))&":"&IF((B1-ROUNDDOWN(B1/60,0)*60)<10,"0"&(B1-ROUNDDOWN(B1/60,0)*60),(B1-ROUNDDOWN(B1/60,0)*60))

Hope this helps!

PReagan

[#3]

@Hardik_Gadhavana 

That could be

=TIME(1,10,0)+(A1-14)*5/24/60

[#4]

@Hardik_Gadhavana 

It appears that you want to multiply A1 by 5 minutes and return the result formatted as hh:mm. Thus, you need this formula in B1, copied down rows: 

=A1*TIME(0,5,0)