between times

  1. T

    GANTT schedule - Take value if between time and equipment criteria match

    Hi, I need to make a GANTT schedule from the production with tanks etc. I cannot get the different formulas to work, when they do I will add it as conditional formatting in different colours. In D2 "Gannt Mrexcel.jpg" I want TRUE if C2 find a match in H:H "Raw data Mrexcel.jpg", also the date...
  2. E

    Total hours that fall between two times

    Hi All, Need a formula to calculate total number of hours that fall between 2 specific times as below. Formula should go to Unsociable Hours Column (F) <tbody> From 20:00 In the evening To 08:00 in the morning Ignoring the break!!! Employee IN OUT Break (mins) Total Hours...
  3. A

    Formula that compares dates and then times from that date row and returns a result

    Hi I've got two data sets, on two sheets in the same workbook. The first is a set of columns signifying actions. It includes date, time action started and time action ended. The second is a set of resulting actions that may or may not have occurred on the same date and between the times. It...
  4. H

    Using Times to make an IF statement

    I have a spreadsheet set up with Column B having a Start Time, Column C having a Duration, Column D having a calculated End time based on B and C. I then have 7 columns of "does this backup happen on this day of the week?" with Yes or No in the field. Then I have a 12:00am, 1:00am, ... 11:00pm...

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