worked

I need to find a formula to take the highest hours worked in column d, then give the code in column C. I created column E as an example of the answer, I am looking for

Hi there, it's been a while since had such a hard time figuring out what I need to do with certain formulas. My question is this. I have a sheet with days and the overtime that is worked on those days. The overtime is split up in 4 categories. OT, DT, PPH, PPH OT. Now the target for the...

Hi I want to write a formula to calculate overtime. If the total hrs worked is more than 8 then that is overtime I thought abut this formula but did not work. It only work if the difference is 1hrs and above. if it is 1/2hr then I get garbage number. = max(A1-8,0) <tbody> total hrs worked...

When adding the Hours Worked for each it is not calculating properly, 12:00 + 10:00 + 10:00 + 12:00 is adding up as 22:00 instead of 44:00. Can anyone help with this? Shazz x

Hi Experts, Looking for a solution to filter down list of emplyoees less than today date. =Table.SelectRows (#"Filtered Rows", each [Last Day Worked] < DateTime.Localnow()) The code above gives me an error, Expression.error: We cannot apply operator < to types DateTime and Date. Last...

Hi I'm trying to work out how to calculate productivity for a team based on the number of days worked this month so far. Normally it would be a very straight forward total/av days. However of the two people in the team, one has worked 8 days this month and the other has worked 5. my question...

I run a restaurant and need some Excel help. I have a sheet and on that sheet are four columns. Column 1- tips earned Column 2- tips earned with a food runner Column 3- name of food runner/ runners that worked(if they worked) Column 4- amount of check written to servers We write checks at...

Hello All :biggrin: I have a spreadsheet I use to pay our employees on a 4-weekly basis. We also include a production bonus, which we're modifying to a performance based one. My head is a little pickled!... I have a cell with a "Bonus Pot" for the month - this is the ££ figure I have to share...

I'm working on a spreadsheet for work. I have three columns I'm working with. One has names, the second has hours worked, and the third has the account it would come out of. I need the formula to add the hours worked if the names in the first column are the same, but it needs to not add the...

Hello Need help with a formula that will return breakdown of weekly hours worked as Regular ( 40 hrs) and OT ( result of hours worked over 40) But if worked less than 40 hours - then show actual hrs worked and if no OT wasn't worked, then show a result of '0' Thanks in advance for your help ...

Hi, For a few days now i have been having problems whilst making forms etc. Some good members here has advised the code or edit to use but when i copy from her & paste into my sheet i see errors etc. The member who put the advice here did not see any errors at all & as such worked 100% for...

Hello, I've been using the following formula for months now without problem (or so I thought) & it worked in the month of August (which had Five Fridays in the month), but for some reason it is not calculating properly for September. Formula...

Hi there! On an Access report, I'd like to add the total hours worked based on 4 fields that produce the following times: 1. initial daily log in, 2. log out for lunch, 3. back in from lunch, and 4. End of Day logout. Can I use the Expression Builder (Design View>Property Sheet>Data...

Good morning, everyone! I would like some suggestions for changing a personal budget spreadsheet I have been using for a few years. On the Expense sheet, the cell next to Wages (L33) utilizes adrop-down menu which pulls data from a sheet titled Bi-Weekly Wages (='Bi-Weekly Wages'!$B$4:$B$220)...

Okay, so I have scoured the Forum's and the web in general. There is a lot of info on how to calculate time but this is not addressed. I need to calculate hours worked between 9:00 PM - 12:00 AM when the employee works over midnight. Example: Start 9:00 AM Stop 2:30 AM should equal 3 because the...

I'm building a time card calculator to compute number of hours worked per day Clock In/Clock Out...need HELP rewriting the following formula... =MROUND(IF((OR(B13="",D13="")),0,IF((D13<B13),((D13-B13)*24)+24,(D13-B13)*24)-C13/60),1/60) I need this formula to calculate exact time/hours and not...

Re: How to count Sundays worked in a specific month based on a cell value Hi All, I need to count the Sundays that an employee worked in a month. The below table is what I am using. According to this table the employee has worked one Sunday out of the two Sundays shown in the table. The...

Can anyone tell me how to auto change dates based on hours worked? All tasks are sequential, so row 2 "end date" will be the "start date" of the row 3. <tbody> Task Hours Worked Start Date End Date Task#1 8 09/15/2018 Task #2 16 </tbody> Your help is greatly appreciated.

Re: How to calulate hours worked on Sundays in a specific month Hi, I would like to know how to add all hours worked on the sundays in a month. An employee might not work every Sunday in a month. Some employees will work one Sunday, others might work 2 or more and some might not work any...

Hi, I am facing issue to get the result of Regular hours and over time based on the following conditions. Input is as: A1 = Start Time B1= End time Conditions as: <tbody> Regular hours Over Time (1x) Over Time (1.5 x) Over Time(sunday- 1.5x) Over Time Sunday(2x) 8:00 AM to 5: PM 6:00 AM...