The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions may be imposed.
HOW TO ATTACH YOUR SAMPLE WORKBOOK:Unregistered, Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
New Notice for experts and gurus:
Recently, it has become clear that some members (especially newer members) have been confused by "mixed messages" coming from non-Moderators. They are unclear how to react to such requests. Accordingly, we are now asking all members NOT to attempt to moderate threads. From now on, that will be done by forum Moderators only.We continue to encourage the reporting of posts/threads where cross-posting has not been declared, where measures to bypass sheet security are requested, or where abusive language is being used. Generally speaking, it it NOT necessary to report poor titles, spam, lack of code tags, etc, as these are easily spotted by forum Moderators.From now on, those posts made by non-Mods that are attempting to carry out Moderation activities will be deleted.

Search:

Tag: rota

Search: Replies Views Search took 0.00 seconds.

Rota Generator

Started by TomMartin123‎, 05-17-2024 07:03 AM
- 4
- 570
Last Post By:

Last Post: 05-24-2024 12:18 PM

by JeteMc

Forum:
Excel Formulas & Functions
Automating Time Values on a Work Schedule (Rota)

Started by hvb128‎, 02-20-2021 08:45 AM
- 2
- 711
Last Post By:

Last Post: 02-23-2021 03:00 PM

by JeteMc

Forum:
Excel General
Break Rota with VBA.

Started by hyding‎, 09-07-2020 02:09 PM
- 16
- 633
Last Post By:

Last Post: 09-12-2020 06:14 PM

by TMS

Forum:
Excel Programming / VBA / Macros
Counting occurrences of sickness in a roster across a year

Started by thomascymru‎, 10-31-2019 12:27 AM
- 17
- 1,501
Last Post By:

Last Post: 11-07-2019 05:20 AM

by menem

Forum:
Excel Formulas & Functions
[SOLVED] COUNTIF between two times

Started by doodlelurch‎, 12-06-2018 09:33 AM
- 7
- 1,540
Last Post By:

Last Post: 12-06-2018 10:45 AM

by Bo_Ry

Forum:
Excel Formulas & Functions
[SOLVED] Formula for time displayed within a staff rota

Started by ~TaC~‎, 11-13-2018 05:45 PM
- 6
- 564
Last Post By:

Last Post: 11-15-2018 06:18 AM

by ~TaC~

Forum:
Excel Formulas & Functions
Sorting export Data

Started by Dominic.Brice‎, 03-27-2018 11:35 AM
- 13
- 904
Last Post By:

Last Post: 04-04-2018 09:10 PM

by jindon

Forum:
Excel Programming / VBA / Macros
[SOLVED] Formula to get times from range of cells

Started by ~TaC~‎, 02-24-2018 05:09 PM
- 4
- 813
Last Post By:

Last Post: 02-24-2018 08:25 PM

by ~TaC~

Forum:
Excel General
[SOLVED] HELP needed for staff rota

Started by ~TaC~‎, 11-13-2017 02:20 PM
- 24
- 1,599
Last Post By:

Last Post: 11-23-2017 07:31 PM

by ~TaC~

Forum:
Excel Formulas & Functions
[SOLVED] Populate automatic ROTA by date

Started by manny88‎, 11-29-2016 07:04 PM
- 4
- 3,594
Last Post By:

Last Post: 11-30-2016 06:15 PM

by manny88

Forum:
Excel General
[SOLVED] Error on complicated Vlookup/GetPivotData Formula

Started by manny88‎, 11-09-2016 05:49 PM
- 3
- 903
Last Post By:

Last Post: 11-10-2016 09:37 AM

by dosydos

Forum:
Excel Formulas & Functions
24x7 Roster - 12h shifts - 8 staff

Started by nwadham‎, 10-27-2015 08:29 PM
- 1
- 2,331
Last Post By:

Last Post: 11-18-2015 09:31 AM

by nwadham

Forum:
Excel General
I need an excel template to work out break times and lunch breaks for an office....help!

Started by jgfoxy‎, 08-16-2015 04:51 AM
- 1
- 3,041
Last Post By:

Last Post: 08-16-2015 02:14 PM

by BlindAlley

Forum:
Excel General
Formula for individuals to view their hours.

Started by samuelleach‎, 07-17-2015 08:22 AM
- 2
- 915
Last Post By:

Last Post: 07-17-2015 01:30 PM

by samuelleach

Forum:
Excel General
Employee schedule/rota - how to add shifts into total hours easily

Started by gavinbox‎, 03-02-2015 07:59 AM
- 0
- 1,030
Last Post By:

Last Post: 03-02-2015 07:59 AM

by gavinbox

Forum:
Excel General
Rota formulas

Started by cllamas‎, 02-23-2015 06:38 PM
- 0
- 902
Last Post By:

Last Post: 02-23-2015 06:38 PM

by cllamas

Forum:
Excel Formulas & Functions
[SOLVED] Help with Totals using VLOOKUP/SUMIF for employee timetables.

Started by mjt31‎, 07-06-2014 06:56 PM
- 4
- 1,567
Last Post By:

Last Post: 07-10-2014 12:54 AM

by FDibbins

Forum:
Excel - New Users/Basics
Create An All In One Performance Management Workbook

Started by pringle1987‎, 06-24-2014 04:54 AM
- 0
- 717
Last Post By:

Last Post: 06-24-2014 04:54 AM

by pringle1987

Forum:
Excel Programming / VBA / Macros
New Joiner

Started by shiftpattern‎, 12-28-2013 01:54 PM
- 1
- 664
Last Post By:

Last Post: 12-29-2013 10:30 PM

by vlady

Forum:
Hello..Introduce yourself
Need help relating a list of random numbers to a list of names so that i can create a rota

Started by Macjay22‎, 11-21-2013 04:28 PM
- 3
- 2,504
Last Post By:

Last Post: 11-22-2013 05:06 PM

by newdoverman

Forum:
Excel General
Help with a rota

Started by Jayblath‎, 11-13-2013 05:46 PM
- 1
- 830
Last Post By:

Last Post: 11-13-2013 07:34 PM

by bmxfreedom

Forum:
Excel Programming / VBA / Macros
Rota, Roster, Work Schedule, Timetable, Staffing Allocation

Started by spoursy‎, 09-28-2013 02:26 PM
- 1
- 2,527
Last Post By:

Last Post: 09-29-2013 04:33 AM

by Pepe Le Mokko

Forum:
Excel General
My Christmas Grotto Staff Roster Needs the Help of an Excel Expert...

Started by wisematthew‎, 09-20-2013 12:28 PM
- 3
- 1,188
Last Post By:

Last Post: 09-22-2013 03:53 PM

by alansidman

Forum:
Excel Programming / VBA / Macros
Shift Rota/Calendar 5 crews Rotating Shift

Started by Flynn Rider‎, 09-16-2013 06:16 AM
- 4
- 5,578
Last Post By:

Last Post: 10-07-2013 08:03 AM

by Flynn Rider

Forum:
Excel Programming / VBA / Macros
I'm struggling to get a formula to populate a list

Started by Macjay22‎, 09-10-2013 02:34 PM
- 5
- 1,280
Last Post By:

Last Post: 11-30-2013 07:37 PM

by Macjay22

Forum:
Excel Formulas & Functions
creating a staff rota for 24 hour shifts

Started by RONJONES‎, 09-06-2013 07:20 AM
- 4
- 15,425
Last Post By:

Last Post: 09-06-2013 12:02 PM

by Ursul

Forum:
Excel General
Rota - working out unpaid breaks

Started by mcedge‎, 05-23-2013 07:48 AM
- 1
- 1,301
Last Post By:

Last Post: 05-23-2013 09:51 AM

by ARGK

Forum:
Excel General
Is this Possible?

Started by CRS-‎, 05-21-2013 07:30 AM
- 1
- 724
Last Post By:

Last Post: 05-21-2013 08:21 AM

by Special-K

Forum:
Excel Programming / VBA / Macros
[SOLVED] Formula: To calculate duration between two times, if duration is over 6hours subtract 30mi

Started by MattBarnes7‎, 01-11-2013 02:54 PM
- 2
- 3,244
Last Post By:

Last Post: 01-11-2013 03:22 PM

by MattBarnes7

Forum:
Excel Formulas & Functions
Excel Rota - Help

Started by Osborneian‎, 11-23-2012 02:02 PM
- 1
- 780
Last Post By:

Last Post: 11-23-2012 03:05 PM

by Steve N.

Forum:
Excel Programming / VBA / Macros
[SOLVED] Formula to calculate if employee is working on each half hour

Started by holowugz‎, 07-15-2012 10:07 PM
- 10
- 1,742
Last Post By:

Last Post: 07-16-2012 08:29 PM

by MarvinP

Forum:
Excel General
Can't complete an IF statement, can you?

Started by Graememgparker‎, 06-22-2012 04:55 AM
- 1
- 894
Last Post By:

Last Post: 06-22-2012 05:19 AM

by zbor

Forum:
Excel - New Users/Basics
Creating a staff rota

Started by daustin3‎, 05-16-2012 12:30 PM
- 0
- 3,202
Last Post By:

Last Post: 05-16-2012 12:30 PM

by daustin3

Forum:
Excel General
Adding hours for split shifts

Started by fingus‎, 07-07-2010 11:50 AM
- 7
- 5,019
Last Post By:

Last Post: 07-07-2010 05:00 PM

by Paul

Forum:
Excel General
Excel 2007 : Visual representation of rota

Started by Thintin‎, 11-09-2009 12:30 PM
- 5
- 2,110
Last Post By:

Last Post: 11-14-2009 06:50 PM

by Thintin

Forum:
Excel General

Results 1 to 35 of 35

Search: Replies Views Search took 0.00 seconds.

[SOLVED] COUNTIF between two times

[SOLVED] Formula for time displayed within a staff rota

[SOLVED] Formula to get times from range of cells

[SOLVED] HELP needed for staff rota

[SOLVED] Populate automatic ROTA by date

[SOLVED] Error on complicated Vlookup/GetPivotData Formula

[SOLVED] Help with Totals using VLOOKUP/SUMIF for employee timetables.

[SOLVED] Formula: To calculate duration between two times, if duration is over 6hours subtract 30mi

[SOLVED] Formula to calculate if employee is working on each half hour