comparing time values

  1. E

    Complicated Time Checking in VBA

    Problem Statement: Approved code deployment windows are 1) Overnight (10 pm – 6 am EST) 2) Lunch (12 pm – 1:30 pm EST) 3) Evening (5 pm – 6 pm EST) - but people don't follow the rules. I get automated emails whose 1st line contains deployment results e.g. CMD_START: WS restart on...
    • erickat
    • Thread
    • check comparing time values deployment disptime time
    • Replies: 9
    • Forum: Excel Questions
  2. A

    VLOOKUP for Times, Not Matching based on rounding?

    I'm having a problem getting a VLOOKUP to work where Excel thinks the times 3:45 PM and 3:45 PM don't match. Both are formatted H:MM AM/PM. When I evaluate the formula it shows that one is 0.65625 and the other is 0.65624999999999. The one it marks as 0.65625 is generated from the formula...
    • ARW17
    • Thread
    • comparing time values excel 2007 vlookup vlookup doesn't match
    • Replies: 1
    • Forum: Excel Questions

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