Can I multiply a number and have it display in minutes?

[siasarma]

I am trying to multiply a normal number (1,2,3 etc...) by 20 minutes and have it display in in hours or minutes, whatever it may be. Example:
If you do not take a break at my work, you get paid an extra 20 minutes. So I want to be abel to Have a place on the timecard that goes something like this:

ColumnC Column D Column E Column F
No Break: Quantity 1 (display in hours and minutes.)

So I want to be able to change the 1 in Column E to how many breaks they didnt take and have it multiply by 20 minutes and display how much time is added to there time card in Column F.

Thanks for your help!

 

[Scott Huish]

=A1*"0:20"
Format as h:mm

 

[siasarma]

YOUR A GENIUS!!! THANKS!!! I was so close, I just couldn't quite get it! Thank you!!!!

 

[wprager]

If the multiplier goes past 71 you'll want to format the result cell as [h]:mm, otherwise you get the 24-hour wraparound (72 * "0:20" becomes 0:00). That's a lot of missed breaks, but if you are compiling the info from multiple time sheets then it could get that high.

 

[siasarma]

That's great to know! I probably would have found out the hard way! Thank you!!!