code shortening

  1. C

    Simplifying VBA Script

    I am trying to rewrite the following script to increase efficiency and make it easier to enter a list of files that need to be opened. The whole process utilizes the following: -Compile File (This is where all the data will be pasted from various source files). All pastes in the compile file...
  2. L

    Time rounding and decimalisation formulaes

    Hello MrExcel Patrons, I have to create a sheet whereby i can enter the values for staff starting times, but they will be exact, for example. 8:23, this figure would need to be rounded to the nearest 15 minute, whether that be up or down. Furthermore i need to calculate from these times the...

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
Back
Top