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

siasarma

New Member
Joined
Sep 20, 2008
Messages
46
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!
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

siasarma

New Member
Joined
Sep 20, 2008
Messages
46
YOUR A GENIUS!!! THANKS!!! I was so close, I just couldn't quite get it! Thank you!!!!
 

wprager

Board Regular
Joined
Jul 29, 2008
Messages
141
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

New Member
Joined
Sep 20, 2008
Messages
46
That's great to know! I probably would have found out the hard way! Thank you!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,132,668
Messages
5,654,644
Members
418,146
Latest member
Shnn028

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top