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...
I am wondering if there is any other way to somehow link two functions together, to add hours in a timecard. I would like to be able to use decimals, but not have it convert into fractions. Example: I want to be able to go:
Time in - 8.00 time out - 1.00 time in - 1.30 time out - 5.00.
I want...
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.