time check

  1. K

    Time based formula

    Hi, Can any one help me with a formula that enables excel to copy a value in a cell at a particular time of the day. for example: A1 is having value which it gets from an external web source and is being refreshed every minute. i want the value in A1 at 10:00 AM every day to be automatically...
  2. Z

    VBA: groups in table with time selection (Excel)

    I try to conditionally select rows from 3 groups. I have a table that can be divided in 3 groups (defined by 3 values of column B) as shown in attachment. I would need to find out the following: if group 1 (value '1G') appears, then if group 2 (value '3G') appears within 10 minutes, and then...
  3. I

    time worked calculation

    time worked calculation over 2 days the company I work for has a rule where we can only work 12 hrs in any 24hr time period how can i work this out in an excel spreadsheet if eg: Day 1 start shift 11:30am finish 21:00pm, day 2 start 7:00am finish 16:30pm I'd like to work out how many hr...
  4. WERNER SLABBERT

    I have need of some know how...

    In a project i am compiling i need to work accurately with times to calculate the work progress of the people in the workshop thus....here goes.... I have in work book #1 (7) sheets mon to fri + complete week + a sheet where all job numbers are collected. From monday to friday the workmen log...
  5. I

    How to check for time and if ok to run?

    I have an application which users are not supposed to use between 5pm and midnight due to production jobs running and changing data. Does anyone have a code snippet which shows how to check a PC's time to determine whether or not a macro is runnable? That is, if it is between 5pm and midnight...

Watch MrExcel Video

This Week's Hot Topics

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
Top