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...

Some videos you may like

This Week's Hot Topics

Top