7am

  1. J

    Run a Macro on the 1st of every month at 7AM

    I have a workbook that is set up to always stay open with a Private Sub Workbook_BeforeClose function. I have written a macro called Save_And_Clear to perform a number of routines on the 1st of the month at 7AM. The Save_And_Clear macro works great but I’m having a hard time figuring out the...
  2. J

    I need help writing a formula to return a value between 2 dates and time

    I need to write a formula to return the date between 8am and 8am the next day. So if in cell A1 I have 8/24/2018 7am it would return 8/23 but if I have 8/24/2018 9am it would return 8/24. Any suggestions?
  3. D

    Total hours between two times in same cell

    Hi there, I'm working on a staff register and would like to calculate the total hours worked, my problem is I want the start and end of the shift to be in the same cell, I'd also like to deduct break time (as we don't get paid for breaks). Here's an example of what I'm looking for: <tbody>...

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