Hi all, I have a dillemma here, I have to create a schedule which incorporates lunches automatically (either half hour or 1-hour lunches, depending on the circumstances). The schedule only has time in and time out, but I need excel to automatically deduct the lunch break depending on the circumstance: If you worked less than 6 hours = no lunch If you worked more than 6 hours, but less than or equal to 8 hours = 0.5 hour lunch If you worked more than 8 hours = 1 hour lunch I am assuming the formula for this will be really long, but I have looked online everywhere and have not found ONE formula for it. I can't put lunch breaks seperately, so all I have to work with is Time in/out. Also, I wouldn't be able to use military time, so I don't know how excel can assume that time in is in the morning, and time out is in teh evening and/or half-day. If someone can help it would be greatlyyyy appreciated. Hello, Please help!!! We have a client who will pay using the 1/4, 1/2/ and 3/4 of an hour increments as follows: From the hour mark to 6 minutes = 0 time paid Over 7 minutes to 15 minutes = 1/4 hour 15 16 minutes to 30 minutes = 1/2 hour 30 30 minutes to 45 minutes = 3/4 hour 45 46 minutes to 60 minutes = one hour. They work on shifts and the operation is 24 hours. Each gets 30 minutes for breaks which is not paid. Pay is biweekly and overtime is anything over 40 hours. Currently, the template we are using looks like this (sorry, I could not figure out how to paste it so you can see it in Excel layout): WEEK 1 Sunday Monday Tuesday Wednesday Thursday Friday Saturday 5/16 5/17 5/18 5/19 5/20 5/21 5/22 TIME IN ENTER TIME, INCLUDE AM OR PM TIME OUT TIME IN TIME OUT TIME IN TIME OUT TIME IN Total Hours First Week TIME OUT HOURS WORKED-OR- choose one *HOLIDAY WORKED PAID HOLIDAY (not worked) *OTHER PAID HOURS EXPLANATION OF *HOLIDAY WORKED HRS OR *OTHER I am very new to Excel and need help creating a formula that will allow us to calculate this timesheet? I am in desperate need for help. Hello, this is probably a bit of a newbie question but I need to work out how many hours off someone has had. I'm after a formula which looks up through the cells and for every 0 it finds it adds 24 to a total. Free online time sheet for HGV Drivers. Daily, POA and WTD hours, copies to office/driver. I'm trying to come up with a solution to calculate the man hours and days worked over multiple sheets. I have a file that has 8 sheets. The first seven sheets are the days of the week and the 8th sheet is where I want to calculate the hours. The days of the week consists of 'Name' 'Date' Hours' The 8th sheet consists of 'Name', 'Days of the week in their own column (7 columns in total)', 'Total Hours' and 'Total Days Worked' Now. Each day is always a different group and what I'm hoping for is to create a formula that can grab each name with their hours and throw them into the 8th sheet. So when the end of the week is done I have all the Employees weekly hours and days worked all finished. I hope this makes sense. This file is to track about 100 employees that are on a rotational work schedule. I have attached a sample file. Thanks in advance for your help. Hi, I made a simple worksheet that we have been manually entering the time for employees, but there are too many errors (even with simple math). Can someone help me convert the time of ex: written 8-4:30 or 10-3 (meaning 8:00am to 4:30pm) where you have the total weekly hours? Right now I have a column for overtime. Is there a way to automatically calculate the over time also? The work day is 8-4:30 with a half hour lunch (lunch is not calculated into the hours, so you minus a half hour). 8-4:30 equals 8 hours. So, if a person works 8am to 6:30pm, how can I set it up where in the first row of time, I will type in 8-6:30pm. In the totals column to the far right, it will display 8 hours. In the (O.T.) column, it will display 2 hours. This way, when I call in my payroll, I will have the total 'regular' hours in one row and underneath, I will have the total overtime hours. Does anyone have a better solution to keeping track of their hours? Good afternoon! I'm working with Excel 2003 sp 3 on Windows xp. I have been banging my head trying to jar loose the formula to calculate man days where 1 equals 8 hours. I have one that was given to me by a coworker: =INT(Q3/8)+(((Q3/8)-(INT(Q3/8)))*0.8) That calculates man days from total hours. I need a formula that will total man days and return the man day answer. Example: weekending 12/25 = 16.2 which is 16 man days and 2 hours weekending 1/1 = 24.7 which is 24 man days and 7 hours Total = 41 man days and 1 hour I have also been asked if there was a way for a number to be entered into a spreadsheet and automatically put in order without a macro or 'pushing a button'. Any advice is greatly appreciated!
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2018
Categories |