# Creating Simple Monthly Work Schedule For 6 Employees But Need To Tally Hours

Aug 19, 2013
Maybe it is the layout but I was trying to keep it simple and just put hours into a cell for each employee.

I have 2 employees per day, one in the morning and one in the evening. How to get excel to add the hours for each employee at the bottom per month. Simple right?

Here is an example of what I thought would be so easy (first week in excel spreadsheet format)

sun mon tue wed thu fri sat

emp1 5 emp3 6 emp5 5 emp1 4 emp3 5 emp5 5 emp1 6

emp2 5 emp4 5 emp6 5 emp2 5 emp4 5 emp6 6 emp2 6

Is there a way to associate cells to look at values for each employee and add all the cells for the month?

View 5 Replies
ADVERTISEMENT
Nov 28, 2013

I am attempting to create a rotating weekend work schedule in Excel to make life easier. There are 30 people who rotate Saturday's and Sunday's every month. Technically, they are only supposed to work 2 weekends a month, and am attempting a way to create this in Excel to make it more fair to the group instead of just picking and choosing which weekend these employees work, I would like an Excel program to do this for me.

View 1 Replies
View Related
Apr 15, 2014

I have to calculate employees work hours for overtime.

in the timesheets:

A B C D E

1 ID Date Code Hours PayMethod

2 A123 4/14/14 TRN 20:00 Regular

3 A123 4/14/14 TTT 15:00 Regular

4 A123 4/14/14 TRN 13:00 <----- total for cell D2,D3, and D4 is more than 40

A B C D E

1 ID Date Code Hours PayMethod

2 A123 4/14/14 TRN 20:00 Regular

3 A123 4/14/14 TTT 15:00 Regular

4 A123 4/14/14 TRN 5:00 Regular <----- to make 40

5 A123 4/14/14 TRT 8:00 Overtime <----- 13-5=8, so i have to write down 8 here for overtime

How can I do this?

I want to make a command button for macro to perform this.

View 2 Replies
View Related
Aug 29, 2009

I am working on a monthly employee work schedule that has 2 stores. All employees work at both stores and the boss wants 2 separate schedules.

I have attached what I have started, which at the moment I am stuck.

I would like to have the Row 5 total hours to always reflect (subtract) a 30 minute lunch. I know it would be easier to have another column, but the boss wants it this way,

I also need the total hours in column H to reflect the total of each day (with the subtracted lunch break). In this column I am having the figures turn red if over 40 hours and green if it under 40 hours.

With having 2 stores with the employees working at both, I need to somehow have the hours of the employees add up from one store to the other (a running total, if you will).

Lastly, if I have an employee not scheduled for a day or need to put other data such as, VAC, HOL or blank cell etc in a cell, how can I get this to work and not have the formula go nuts when it is not in a time format.

View 14 Replies
View Related
Dec 9, 2013

After much searching today I've been unable to find a way to do this. All my searches resulted in some generic looking site looking to sell me some scheduling software.

I have a team of 7 people and I need one person to work a late shift each day of the business week. M-F

I would like a way to have the schedule automatically advance to the next person.

View 1 Replies
View Related
Jun 27, 2014

As you can see on the example i have TEST hours.xlsx, I have a file that calculate the money every doctor should take based on the working hours.

Nights, holidays and holiday night have different price/hour.

The excel is working fine…but now I have to make a formula that separates automatically based on the beginning time and the end time of the doctor’s shift the day hours tha night hours, the holiday hours and the holiday nights hours.

In the excel I have fill the hours Manuscript, I need a formula to do that for me…

On the yellow cell I have try to find out the formula for the holiday hours but because the day is calculated due to a formula it is not working!!!

Simple Example: A doctor Is working from 21:00- 8:00 (next morning Sunday) he should have 1 simple hour (21:00-22:00) 9 night hours (22:00-6:00) and 2 holiday hours (6:00-8:00,)

View 1 Replies
View Related
Jan 24, 2014

Essentially I'm in charge of managing schedule for 5 students, I would like to get them to meet during their free time (free for all 5 of them)

1. Schedule has to run from 8 am to 9 pm.

2. I have all 5 individual schedules.

I want to combine all 5 into one so everyone can see their free/occupied times, it would be extra useful if I can modify individual schedules (One student's work schedule changes bi weekly).

It has to be able to show who is occupied at which time and free time for all of them. (color coding each of them would be amazing also, granted I can show multiple clashes with gradient or something similar)

I understand it involved creating individual spreadsheets and a master sheet but how to go on about it.

View 1 Replies
View Related
Aug 16, 2008

Her situation is that she would like to be able to tally all the work orders that are created and either completed or pending. According to what she tells me she usually spends hours tallying the monthly worked on orders manually....

View 15 Replies
View Related
Mar 14, 2014

We want to create an excel spreadsheet that will tally the number of votes for a particular artist's work. There will be about 150 artist's works that will all be assigned an individual number from 1 to 150 on an excel sheet.

We will have about an hour to complete the counts to determine winners, so a short time frame.

Is there a way of creating a formula/macro in one cell -to just enter the number of the artist's work that was voted for- and have it placed as a tally against the individual piece?

View 3 Replies
View Related
May 31, 2014

Im doing a spreed sheet to calculate employees hours. I have the employees names in column R and their hours in column S. example R5 = Mike S5 = 8. I need to search column R for all the mike's and total his hours, then move to the next employee and so on... I have already sorted the employees names so that all the names and hours correspond and starting in column R5 and S5 until the proceeding row is blank and then paste the results in column B5 (employee name) and D5(total hours)

View 4 Replies
View Related
Mar 30, 2012

I need to create a formula that assumes 40 hours = 1 FTE (full time employee). As an example if I have a total of 100 hrs I need to know how many employees to hire. So in this case it would be 2.5.

View 1 Replies
View Related
Jan 30, 2013

Need VBA macro to read and sum data from multiple worksheets

The “summary” worksheet contains list of all employees. I need to update the total number of hours for each employee by scanning all worksheets in the workbook as follows:

Once I click on a "update" button, I need to scan all worksheets (I have one worksheet for each week) which contains the total number of hours for employees by week. I need to calculate and add the total number of working hours for each employee then move to the next worksheet and so on ..

Once all worksheets are all scanned, the final total of working hours get posted in front of the employee name in the assigned field.. I need to do this for all employees. I also need a macro to create a new worksheet.. I attached an example with little description inside .. Labor Detail Job to Date-2.xlsx

View 5 Replies
View Related
Apr 12, 2007

I have an excel document and I don't know which formulas to use. Here is how the document is laid out, it's an employee schedule.

The row includes A: Name B: Sunday C: Monday ... J: Total

Columns below include the employee names. What I am doing is filling out the employee schedule and I need excel to calculate scheduled hours. My problem is, when I make the schedule the hours are different than the numerical value given by excel. For example, Sunday I have an employee scheduled from 8-4. That's 8 AM until 4 PM; or a total time of 8 hours. Excel would read that as 8 (minus) 4, rendering the results useless. Once I figure out how to calculate hours by such input, I'll need to make totals which won't be as difficult.

Also, if there is a way to set the value of the word "Close" to 12:15 AM that would be extremely beneficial as well.

View 9 Replies
View Related
Mar 23, 2013

I need creating a formula that will tell me the total number of employee hours worked during a certain hour (6:00 AM) for a particular department. Some employees clock in at 6:00 AM, some clock in at 6:30. Here is the current formula I'm using which only tells me the amount of employees in the department not how many hours worked . I have three employees that clock in at 6:00AM and one at 6:30AM, the total I'm looking for is 3.5 but my formula gives me the result of 4.

C5:C1446 is a list of departments

T1503 is the 6:00 AM

D5:D1446 are the Clock In times

K5:K1446 are the Clock Out Times

=SUMPRODUCT(--($C$5:$C$1446="Shipping"),($T$1503>=$D$5:$D$1446)*($T$1503

View 6 Replies
View Related
Jan 8, 2014

Combing these two formulas. I have a work schedule spreadsheet. If the employee is Off I want the value to = 0 (zero hours). But if the cell has a start time I need it to calculate those hours. I know both of the formulas work individually. But I need them to work together.

Formula for when cell says OFF:

=IF(C11="Off",0)

And the second

Formula to calculate hours (based on start time/finish time is the same for all employees)

=($X$4-C11+($X$4<C11))*24

View 2 Replies
View Related
Dec 19, 2009

I have made a work schedule for my local business and have set up a series of formulas that will fill out time cards that I could print out directly onto the paper time cards. The formulas that I have work except that if there are two subsequent entries that later will not return a value and result in an error.

If you could take a look at it that would be awesome. To use it you just need to type a name into the name column and a work time into the time column for that day. then in the other sheets( one for each worker ) it will set up the time card. The the error happens on Thursday, when Bob has an entry right after Fred. Then on Bobs sheet it gives me a #N/A.

View 10 Replies
View Related
Oct 6, 2009

I have a sheet in which in Coloum A I have manager names, then in Colum B I have list of Employees reporting to that manager, then in Column C, I have total login time of each employee which should be => 8 hours. In a new sheet, I want to get the count of employees next to the each manager's name who login time is less then 8 hours.

View 3 Replies
View Related
Jan 26, 2010

I am usuing INDEX and MATCH to pull back employees hours from a master sheet, I am asking excel to Index, matiching firstly the agents name and then the day of the week (Formatted: Mon,Tue,Wed,Thurs,Fri,Sat,Sun). This works perfectly for every day of the week using the following formuls except for Sun where it returns #REF!

=(INDEX(Hours!$B$4:$G$166,MATCH($F$1,Hours!$A$4:$A$166,0),MATCH(C7,Hours!$B$3:$H$3,0)))

View 2 Replies
View Related
May 31, 2013

I am trying to extract times from a work schedule to automatically generate a 'time in' / 'time out' chart. Been trying to use the lookup formula amongst others with little success.

See example template attached...Example Sheet.xlsx

View 9 Replies
View Related
Jul 11, 2014

Each row of the spreadsheet from a6:a25 is the planned production of one cellbuilder.

From this sheet I need to produce a work schedule of tasks to be performed by date.

Detailing, batch, cellbuilder number,weather 1st or 2nd graft etc, and the date available (for picking)

I would like the option to choose a daily or weekly schedule.

Is this possible ? and how would I even start to go about it. I just can't visualise how to do it.

View 1 Replies
View Related
Dec 2, 2012

I am working on an easy to read worksheet for my employees. i have a multi-page schedule that i would like to display on one page, i can make this work using the IF function, how ever i would need to display names not the time they work, how to make this work, i have attached and example sheet of sheet 1 and sheet 2. I am trying to take sheet 2 into sheet three to display names, if they are off to display nothing.

View 1 Replies
View Related
Dec 14, 2013

Please refer to attached sheet.

I am using the attached to schedule the employees. All I want is a formula to add up all schedule hours per week per schedule in cell R2,R3 and R4.

Book2.xlsx

View 2 Replies
View Related
Jun 12, 2009

I am Cuttently creating a schedule in excel for work. the schedule will look like this:

Name.........................Shift

Andrew.......................6-3

Jonathon....................12-7

Kim............................9-5

etc etc

the thing is though this is simple enough but i am trying to use a bar chart to help me show how many people i will have on shift at anytime e.g ...

View 9 Replies
View Related
Aug 27, 2009

which is row D on my excel sheet. I need to fill into another form who works shift D, shift E and shift N. Is there a formula I can use to do this? I have given a small sample of my schedule below.

AB CD 252627ShaunD DDNicoleD EDEmilyE DECathyENEJohnNEN

View 9 Replies
View Related
Jul 16, 2009

I have a spreadsheet representing a month where I am trying to figure out different scenarios for employees. One scenario is that an employee could have to move to a temporary position. In that case, I need to calculate the salary payments to temporary employees in a particular work unit. I've tried several different approaches to this problem, but am still getting the error.

One method has been using this sumproduct formula:

View 2 Replies
View Related
Oct 7, 2009

I developed a 14-day work schedule and I assigned each different job position a number. The different job positions are numbered 1-6 and are as follows: #1=5:30am-1:30pm, #2=6:00am-2:00pm, #3=9:30am-1:30pm, #4=12:00pm-8:00pm, #5=1:00pm-8:00pm & #6=6:00pm-8:00pm. Numbers 1,2,4,5 clock-out for a 30 minute lunch break, while the other numbers do not.

My goal is to insert the numbers 1-6 into the spreadsheet throughout the 14 days for each employee, and have Excel calculate the total number of hours for each employee in the far right column. I would also like "V" & "H" to equal 7.5 hours. This would save a lot of time instead of going through and adding up the hours with a calculator

View 3 Replies
View Related
Apr 15, 2013

I need to create a macro to copy the data from time sheets of different employees into the Master sheet. ie., each employee's time sheet details in to a separate sheet. If any employee fails to provide his/her time sheet details. a mail must be sent to the respective employees regarding the Time sheet submission. I am providing the sample data of my files too.

Intentionally TS_Employee5.xlsx timesheet isn't provided. In which case, I have to send a mail to the respective employee, in order to remind him about the time sheet.

View 12 Replies
View Related
Jun 10, 2009

I asked for a macro to delete the whole row if a duplicate customer number was found in column B. Sometimes, though, my column numbers change. So, logically thinking, I simply changed the criteria, but the macro ONLY seems to work if duplicate customer numbers are in column B only.

This code below won't work if the Customer Number is in column D instead of B even if the reference of B:B is changed to D:D, it doesn't carry the macro over.?

View 3 Replies
View Related
Mar 16, 2009

Im trying to work out the formulae or fuction that will work out the monthly compound rate of a loan.

The loan details are 140,000 at 7.55% APR for 20 years.

View 2 Replies
View Related
Mar 26, 2014

So i got a few macros on a worksheet and one of them is simply :

Sub Pr_Removefilter()

ActiveSheet.ShowAllData

End Sub

Ive worked on the excel a couple of times, everything fine. Then it started crashing upon saving (after changes made that had no possible connection to the macro, on another sheet). After a few painfull trials and errors i located the problem to be this macro button. I erased it, created a new one with the EXACT macro and it works. Why?..

View 1 Replies
View Related