shift

  1. S

    Staff Rotation Help Please- Urgent

    Hi I need help in setting up an excel sheet which can do the following for me: We have 13/14 employees who need to supervise the call centre each day. Each working day has two shift, 8-1pm(AM shift) and 1 to 6pm(PM shift); therefore we use 1 employee 1 shift cover methodology. I need to build...
  2. J

    Formula to Calc Hrs Worked

    Hello, I wonder if I could once again ask for advice. I'm looking for a formula to calculate hours worked per shift based on IN / OUT time. My REGULAR SHIFT runs from 7:00 a.m. to 3:30 p.m. - all other hours are grouped into the OVERTIME column. EXAMPLES: A B C...
  3. Grizlore

    Which shift the date/time falls [for lookup]

    I have a lots of cells which contain date and times (eg 11/11/2010 14:39) these refer to a production date on a particular shift. The shift pattern are quite complicated and illogical to calculate, however the each shift starts at either 07:00, 15:00 or 23:00 Therefore, I was thinking the...
  4. S

    VBA - find and move cells

    I would be very thankful for some help. I have a spreadsheet from a text download so data appears in different columns in different rows. For example, my "inclusions" may appear in R3, Q4, P2, etc., followed by the specific inclusions in S3, R4, Q2 and so on. I am trying to line up the cells...
  5. S

    %age cross over

    All, I have a working week shift pattern for two people over 7 days what I need is a fomula or something that will caculate the % crossover of the two people Please help
  6. J

    Shifting cell data to top row

    I need a macro to shift column data to the top row for a given cell range sharing common data in row A. I need to get from this: <table x:str="" style="border-collapse: collapse; width: 384px; height: 288px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 42pt;" span="5"...
  7. M

    Shift Key Excel 2003 VBA

    I know that I can trap the row and cell selected with Target.Row and Target.Column in a BeforeRightClick, Change etc. event but how can I also tell if a shift (shift, alt, ctrl) key is also pressed?
  8. S

    Workflow Roster

    Hi all, This is my first post to this forum. Hope i get some valuable replies here. :) I am trying to create a simple BiWeekly roster (extendable to Monthly) for my workflow support team using either VBA or worksheet functions though i am not able to proceed further than the design...

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