hourly

I am making a task tracking grant chart using 2 input value Start(Date and time) and Duration(Hourly), to calculate their Finish by simply just Start+Duration/24 as you can see in this sheet. ABCD1TaskDurationStartFinish2Task11201-Oct 06:0001-Oct 18:003Task21301-Oct 06:0002-Oct...

My formula is Daily Rate / (Total Hours * 24) Worked great until I hit a computation with 53 minutes. Background: job pays $45, and can take up to 3 hours, but often takes less time. For the first time, the job only took 53 minutes. The formula returns an hourly rate of $0.08 instead of a...

Hi All Sorry for being a noob but I'm trying to fid a formula that will allocate the time spent on a job EDIT: More details in post#4

Hi, I need to create an IF formula based the following information (my goal is to have a column with hourly rate per employee, whether they are hourly or salary so I can do a vacation accrual - see details below): col BC this column says either SALARY of HOURLY on each line (by employee) col...

Thank you so much for the opportunity to ask questions of the experts (I hope my Q wont be too primitive ). I am summing a column of numbers, using sumif, to only sum the pay of the hourly workers. I typed in the function to do that, and believe it or not it works. But I need the user to be...

Hi, I have thecode below which splits 24 hourly prices into 48 half hourly periods. Iwould like to do something similar whereby I take a daily figure and split thisinto 48 half hourly periods. I have tried altering it in different ways but nosuccess. Any ideas? Thanks for your help. Column A =...

Need to make a (daily) hourly bar graph for my work schedule. The data part would be the name, starting time, ending time. I work like to select a horizontal bar graph view as in the image to produce this graph...

Hi there, I have a worksheet that pulls through hourly sales for the previous trading week. It stores these values for Monday C4:C25, Tuesday F4:F25 and so on through to Sunday. For clarity, lets call that Table 1. I want to be able to compute an average of sales taken within a certain...

Dear All, We tracking our order shipment progress on hourly TAT ( Turn Around Time). Example TAT Bucket 20:54 <24Hrs 23:59 <24Hrs 38:03 >24Hrs <48Hrs These times can be starting with 00:01hrs till 8736:30hrs ( 364 days) , currently i am applying these buckets manually ( by...

I have set my workbook to retrieve data from a website which gives prices of stocks. It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple formula. I am trying to make it so that every time the data refreshes, it recalculates based on the...

I am trying to remember how to use the conditional formatting function to account for press size vs hourly revenue. For example, if the company is running a 300-400 ton press, it should have a net revenue of at least $50 (hourly). I was wondering if there was a way to just input the press size...

<tbody> Target GM% 25% Hourly Cost 4.03375 Hourly Pay Rate $80.00 Hourly Bill Rate $100.00 Hourly GM $15.96625 Pay needed for Target GM $70.96625 Bill needed for Target GM GM% 15.96625% Amount off Target GM% -9.03375% </tbody> 1 2 3 4 5=B4-B3-B2 6=B3+(B4*B9) 7 8=B5/B4...

Hi Slightly weird question and I'm hoping Excel is not going to let me down. I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't - =IF(AND(R3>=T3,R3<=U3),"No","Yes") If I get back "NO" I then...

Hi - I am hoping to divide up hourly data into 15-minute increments. The values associated with the hourly data similar should be put into quarters. The two tables below are a small sample example. The first is the data I have now and the second is that data as it should look. I just need the...

Hi, Thinking of ways I can trigger a macro hourly without using application.ontime application.ontime can cause issues and I don't find it too reliable. My idea was to have a cell containing current time =Now()-Today() Then cells with a 1/0 flag for each hour Worksheet_Change event with if...

Hi all, I am trying to forecast hourly teachers salary for the rest of the year. This particular teacher works 32 hours per week, 45 weeks out of the year and paid hourly wage of $20/hour. How do I write a formula so that it calculates monthly salary for the whole year. This teacher does not...

hi there you would think my issue would not need 'me excel' but as much as i try , i cannot resolve. my issue is to insert a start time ie 07:oo and end time ie 16:00. deduct 8 hrs and any over the 8 eight hrs is overtime payable at 1.5 hourly rate. Saturday would be all the hours at...

Hello all! Almost all Gantt charts I see online are for kind of long term projects, as every column is a date. Is it possible to have an hourly Gantt chart for a working day (for instance, from 9 AM until 10 PM)? And also, can I have multiple tasks in one row? Let's say there's four team...

I have a summary spreadsheet that pulls data from other spreadsheets within the workbook. How do I get it to sum the current column and place the sum formula, then look at the spreadsheet that I pulled the data from and get that column total and place that formula total below the previous then...

<o:p>I need a macro that will look down column F and look for the criteria below and then look at column M and put a different color for each pay class that meets the criteria. Please use a different color foreach Pay Class in the total column:<o:p></o:p> Part Time- anything over 23.99...