Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tea Breaks ??
I'm trying to put together a set of worksheets for work that show up who's
on a tea break at a given time.. The project has 3 tabs at the bottom to choose either DUTIES,,SHIFTS,,BREAKS.. The first 2 DUTIES and SHIFTS work fine....but what i'm trying to do now is get the BREAKS sheets to display the day in 15 minute segments and each 15 minutes display the people who are on a break at that time. The DUTIES screen scrolls down to show each day of the week we are open (Mon to Sat) Row B has all the names of the staff and goes from cell 6 down to cell 31. The breaks are shown in Time format in columns H to K and again in cells 6 to 31. Is there a way that I can get the BREAKS sheets to check the times on the DUTIES sheet and automatically insert them into the relevant time slots. I can send the file if needed. Many Thanks DB :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Breaks | Excel Discussion (Misc queries) | |||
calculating breaks | Excel Discussion (Misc queries) | |||
Page Breaks | Excel Discussion (Misc queries) | |||
Hard breaks in text to soft breaks in Excel | Excel Discussion (Misc queries) | |||
Hard breaks in text to soft breaks in Excel | Excel Programming |