05/04/2018

  1. L

    Using excel to calculate hours open without double counting overlaps

    Hi, I hope someone will be able to help me please. I am trying to work out how long a community centre is open each day. In Column A I have the date, in Column B I have the start time of a booking, in Column C I have the end time of the booking, Column D is the unique hours to count. I want...
  2. N

    Populating a table in excel to assess missing timesheet submissions

    Hello, I am attempting to set up table which will allow me to assess employees who have not submitted a time-sheet. The raw data is as follows <tbody> Employee Number Employee Date Hours 1 Mr A 03/04/2018 8.00 1 Mr A 04/04/2018 8.00 1 Mr A 05/04/2018 8.00 5 Mr B...
  3. M

    Macro Help

    Hi, I have the below table which has 5 colums in it. The data in columns B to D is already populated for me however the only data in column A is found in Cell A2. I have created a macro to auto fill column A ( please see below). In my example I have 236 rows to autofil. My problem is this...
  4. H

    formula to remove /

    I have data in Col D as follows: Book1D1Updated on: 05/04/2018 17:08Fixed assets ReconCell FormulasCellFormulaD1="Updated on: "&TEXT(NOW(), "dd/mm/yyyy hh:mm") I have a formula to extract the month & year =MID(D1,FIND(":",D1)+6,6) I need a formula to remove the / the formula returns...

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