I have a workbook where Sheet 1 Col A is a list of dates. Sheet 2 Col A is a relatively short list of constantly changing names. I need to put this list of names in a repeating fashion in Sheet 1 Col B. Ideally I would like for Sheet 1 to regenerate Col B each time the roster list is changed.
Been trying to come up with a formula that I can use in cells to cost a roster. What I want to be able to do is just input start times into cells and the hours worked is automatically costed out in another cell. The trouble I have been having is that different start times attract a shift allowance eg. before 05:00 you get a 20% loading for the whole shift, between 07:00 and 19:00 is 10% and any finishing time after 19:00 is 15%, don't know how to write the formula to do this.
I am working on this for two days , but I got stuck on the last step. I have a roster for about 35 employees. Calculating the daily hrs was not a problem. But I am doing the roster for one week. And I want employee wise total of hrs worked. I am quite confused as the "sum" formula works for some totals and for others it does not, although all the cells are in the right format. I tried to change the "result" cell to "number" and multiply by 24 to get the hr total as a number, but it does not work.
for example "SUMIF(E1:E57,"rafik",H1:H57)" ( this is the formula for calculating hrs for "rafik" on monday. the result cell is in "hh:mm" format and gives me the right total.
Likewise upto sunday the totals are right. What I want to do is calculate the total number of hrs from mon to sun. This seems to be impossible. the formula =SUM(H60:AL60) in a dd:mm format does not work, even =SUM(H60:AL60)*24 in a "number format" does not work.
I have tried "excel help" , tried to change the format but nothing works. The result should be 52 hrs and I cant get it no matter what I do.
I manage an emergency response team which consists of around 50 people, made of 5 different teams and these folks need to take part in emergency exercise to keep their skills up. I'm currently building a training/exercise/ roster database in Excel and would like to add a function that tells me who in each team is due to take part in the next exercise. For info: In the actual workbook, I have names defined on the team members and using vlookup to populate the roster via a drop down list.
To explain the attached example; once the person who is at the top of the list (Name1) has done their exercise, they move to the bottom of the list. Then over time, as the others also take part in execises, Name1 is eventually is back at the top of the list the and it is their turn again (this is quite often known as a Squash Ladder, here in the UK). Is there a way I can vba this process via a button or even better (!) by a drop down list?
i was asked to make a fair rota and i found this 1 on this website its useful but i need to add to it. if you download this work rota you will understand what i mean http://www.ozgrid.com/forum/attachme...0&d=1154640274. i need to find out what the formula/macro is used in this work rota ...its exactly what i need but i need to add saturday and sunday to this rota and more duty columns as their is more employees and when i click the button it randomply places employees in different positions.
I would like to know that if i have seat count available according to floor and weekly off are planned according to team, also seat allocations is given floor wise, however i want to know how many seats are available on each floor or any given day.
I have attached excel sheet : Seat Allocation.xlsx
Make an interactive calendar in excel. I would like to have 3 sheets. One were I can enter the names and corresponding reoccurring roster, that would be days on days off, a second sheet that does all the calcs etc and returns days of which all or most of the people are going to have off at the same time, so we can organise things in advance and maybe a third sheet that shows an actual graphical display of this information like a traditional calendar.
I am currently trying to create a rota / rosta for work which will show people what hours they are required to work, in a format similar to below:
NAME | SAT | SUN | MON | TUE |etc > Person A| 8:00 - 17:00 | 13:00 - 22:00 | OFF | 8:00 - 13:00| Person B| OFF | 17:00 - 22:00 | 8:00 - 17:00| OFF |
This is simple enough to create but I also need Excel to calculate how many hours each person is working in a week and the total number of hours used per day and per week. I found out that I can do this using a formula to work out hours and minutes between two times. However what I would also like Excel to do is deduct the unpaid breaks which the person is entitled to, however this depends on the times that they work, i.e. in the example above Person A would be entitled to a 1 hour unpaid lunch on Saturday, a half hour unpaid tea on Sunday and no unpaid break on Tuesday. Therefore 1 hour would be deducted off the Saturday total hours, 30 minutes would be deducted from the Sunday total hours and nothing taken off the Tuesday.
I am rotating an image on a userform by uploading different gif images to simulate the rotation. There is an annoying screen flicker around the image when changing images that I would like to get rid of if possible. how to get rid of the flicker or a different technique I could use to rotate an image? 1st attempt - uploading different pictures
For h = 1 To Sheets("Bar Contents"). Range("B" & ItemRow) Step 1 PictureLocation = ThisWorkbook.Path & "PicturesTransparent" & Sheets("Bar Contents").Range("C" & ItemRow) _ & " " & h & ".gif" GameUserForm.DrinkAnimation.Picture = LoadPicture(PictureLocation) Sleep 50 DoEvents Next h.........................
I am trying to comeup with an automated excel table that can be used to create a carpark roster.
The carpark has 6 slots for whch I need to roster 9 staff on a weekly rotating basis. This needs to be done in an equitable manner. For example, at the end of a certain period of time, all staff memebers should have had equal chance and on the other hand we shouldnt have instance where a staff member goes two consecutive weeks without a car slot.
I have data map in excel. I want to create a program to flip the data map. The data from the top of the data map will flip to the bottom of the map and the data from the bottom will flip to the top of the map. The process is like a mirror reflection.
after a command button is clicked, the data will changed to be like this:
I am trying to chart a range of dates, for example. I have some boats that are on contract between dates a and b. I would liketo plot several boats with their contract date range. I have tried using a bar chart, but all the lines start at 0. I got it working using an Excel 2007 Stock chart, however, it is in the wrong orientation. I would like to Rotate the Chart 90 degrees, swap the axis, or find a better method all together. I cannot post the spreadsheet as its confidential.
I struggle with my old excel (2003). There is a thing i have to do: put arrows from one sheet which will change its color depending on data, written in some fields. Also there is a task to put these values inside created arrows. I put values using commands:
Worksheets("Map").Shapes("COL").Select With Selection.Characters .Text = Range("Data!E4").Value
Arrows are drawn in different angles using drawing tool. So i need to rotate the text inside the arrows respectively to angle of the arrow rotation. So how is it possible to rotate text inside that shape?
Problem: Have a squad of 8 players in my darts side. We have 12 games in our season and each game requires 4 players so each player will play 6 games. 6 of these games are at home and 6 are away.
I want to create an excel sheet whereby a team will be picked for each match. Each player will play at Home and Away 3 times each. And the same group of players will not play with the other players each time.
eg. Week 1- Team Players, 1, 2, 3, 4 Week 2 - Team Players 5,6,7,8 Week 3 - 1,3,5,7 Week 4 - 2, 4, 6, 8 etc.