 • 443K Members
• 13K Online
• 532K Conversations

# Formula Help

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?

3 Replies

# Re: Formula Help

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

# Re: Formula Help

That could be

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

# Re: Formula Help

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)

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies