worked

I'm working on a time study. I need the formula to convert numbers of hours worked on a task in an 8 hour day into a percentage.

New to spreadsheets. I have created a bi weekly time card based only on hours worked (no clock in clock out fields). I have 3 columns for hours (the actual time worked per day, O/T per day and Reg Hours per day with the O/T subtracted. What I can't figure out how to do is create a code so if...

Hello, I am trying to create a solution to point out employees on a spreadsheet that need to be researched for hours processing. When they have over 40 hours they go on a spreadsheet we have to look at their worked location and hours columns. I was thinking either a Vlookup or maybe even a...

Hello I thought I already posted this question but couldn’t find it anyways here I go I am working on a weekly staffing schedule and it has the follow info type C13 = start time ( 8:30 Am) D13=End-time (5:00 PM) E13 =Hours worked ( subtracting breaks with the following rules ) Works < 6...

Hi I want to find how many hours a user worked. The start time was A1= 10:00 pm and shift finished B1=1:00 am, so this user worked 3 hrs, so when I did C1 = 24 * (B1-A1) I got ################....... How that can be fixed. Thank you very much

Hi Guys, I recently got some great advice on here regarding a function I wanted to get working. I added some code to the vb module, referenced it back in the worksheet and all worked great for a couple of days. Im now opening the *xlsm and none of the calculations are working, just #NAME ...

I have a new desktop computer and since I started using it any Excel file with a macro will run the script and then just close Excel. There are no errors, nor does it matter which Excel workbook I use. These previously worked fine on a different computer, and other colleagues are able to use the...

Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...

So I have a column of formulas. I clicked and dragged to autofill the formulas and at some random point, it stopped working. Can anyone see a difference? =IF(A123=0,0,VLOOKUP(EQUIPMENT!A123,EQUIPMENT!$L$3:$P$2888,5)*B123) This is the last one that worked...

Ok so here is what I'm trying to do. Here are my numbers .. I want to highlight the three lowse numbers closest to zero. Which would be numbers 0.1 , -.08 and 0.9 ... I have tried several formulas but nothing has worked. Any suggestions or the right conditional format formula would be...

Hi I’d like to average hours worked every 5 days but need toexclude days where no hours have been worked. Was playing about with AverageIf to achieve this and wouldn’t be aproblem for the formula in cell below (answer is 9.6). However, if I drag the formula along (Formula 2), the average will...

Hi! I have the old problem of getting Excel to understand time as duration, not time of day. Basically, I want to calculate how many pieces a worker does at the end of day, knowing: pieces/hour and time worked (like 1h30min) I think I got it to understand time, but can't get it to do the...

I have a sheet for the days of the week, and hours within the day. Every hour worked has a '1' in the corresponding cell. Every hour not worked is blank. I need to calculate the number of hours between worked hours. <colgroup><col span="5"><col><col span="3"></colgroup><tbody> Monday Tuesday...

I have had these lines of code in a program for two years. Sheets("ShiftReport").Select Range("B2").Select ActiveCell.FormulaR1C1 = CDate(frmShiftOnDuty.dtpShiftDate.value) It has worked without any issues, in fact this very section of the code ran yesterday. No code changes...

I am building a rota and so have 52 work sheets titled week1, week2, etc... each sheet is identical in layout, similar to below. Assume that cells here run from A1:O5 What I want to do is have all the dates update across the 52 sheets when I enter the 'start' date in week1 Currently I am just...

Good Day excel Guru's! I am a novice with excel but highly addicted! My issue is this: I run a small business and I would like to track my payroll from several departments into an easy to analyze workbook. The trick is that ADP generates a weekly report in Excel format (which ill try to...

Hi - looking for help!! I designed an 'macro enable excel workbook' based health assessment tool a few years ago. It worked fine on versions of Excel as far back as 2003. I have just updated some of the content. A friend helped me with some coding to update a few features. He worked on it...

Good Day I have this this Spreadsheet that calculates time This is the format I have Start Time Lunch Taken End Time Hours worked 7:50am 00:00 11:45am 3:55 4:45pm 00:00 7:30pm...

<tbody> A B C D E F 1 This Wk Hrs Worked Prev Wk Hs worked Prev all Hrs Worked Estimate hrs cumulative hrs New Total Hs 2 2 4 5 10 9 (sum b:c) 11 3 4 </tbody> Trying to understand how I can perform data validation if exceed value in...

ill try to keep this simple. basically i have a start date and an end date of an employee. the first thing i want to do is work out how many days a person has worked over a quarter. so i need something that will work out how many days there are in jan feb and mar and add these together. then do...