worked

Hi guys, I need a VBA to enable the use of expanding / collapsing groups in protected work sheets. Not all work sheets have groups or protection, I'm not sure if that makes any difference. I have tried a few codes from google searches some required a password when the workbook opened which...

Hi - Just a general question, as I'm confused about this. A while ago I created a macro with the macro recorder that uses relative references. I was able to clear the contents of merged cells while using that macro and didn't think anything of it, as it worked as expected. Example (where...

Hello everyone! I'm trying to create a formula in order to be able to have the total hours per position an employee has worked on a different sheet on our database so that i just have to go to that sheet and look for an employee name and have their total shifts worked, total hours worked as a...

Hello, I have the below formula: ="The average driver worked an average of "&ROUND(AVERAGE(F48:G48,H48,F49,G49,H49,F50,G50,H50,F53,G53,H53,F56,G56,H56,F57,G57,H57),0)&" hours per week" The above gives an answer of "The average driver worked an average of 2 hours per week"... I need an answer...

Hi there, I already have a staff timesheet spreadsheet with a formula to determine number of hours worked (cell D1 below), but require another formula to insert a value for 'break time'; if D1 = 6 or more hours worked, I require the new formula to insert "0.5" in C1. If D1 = 9 or more hours...

I have a simple formula X>X where the values of X are decimal numbers returned from an API from CoinMarketCap (cryptocurrency prices). Excel is telling me that .0001 is greater than .0002 I tried using the max formula too and that worked for some cells and not for others (no pattern to this)...

I want to make a staff schedule using a monthly template as in 1-31 sun-sat and have it track hours worked as well. Any help would be appreciated as I am not to savvy with excel

Hi all, I've been struggling with a formula that I am trying to get to work and want to ask if anyone can assist. I have a workbook with named ranges and a named table. The named ranges are called, DATE, NAME, and WORKED. The table is called RATECARD and has headers NAME, RATE, RESOURCE, RATE...

Hi, Please help me with counting the minutes worked on multiple days. For example, on 1-Oct I worked 2 tasks, each one of them have different counting system, that's colon C for(it's a drop list witch is telling me what i did). What i want is excel to calculate how many minutes I've worked...

Hi, I have a workbook that I've used for years. I know it's not best practice but the variables are not defined. This has never caused an issue, it has always worked fine, but today it is giving me a compile error on every variable unless I dim them. Option Explicit is not set, neither is the...

In column F, I have Hours Worked. This number is usually 40, but it could be anywhere from 20-60. In column G, I need to find how many hours they worked between 37.5 and 40. If F13 says they worked 39 hours. G13 should return 1.5 (because 39 - 37.5 = 1.5). If F13 says they worked 40 or more...

Hi, I am trying to write a formula that works out overtime rates. I have a staff member on 25 hours/wk. Until he has worked 37 hours all is plain time, after that it depends on the day, Mon-Fri time+qtr, sat, Sun and bank hols Time+half. The "day of the week" is in col "A", if its a Bank hol...

Ok this might be a good one.... I have a sheet with employee names, time worked, and dates on which the work was completed. Is it possible to have Excel calculate the total time worked by an employee (lets use John as a name example) by the week of the year? For example, the week starting on...

Hi all, I have a rather peculiar problem. I have created a simple OT tracker. [/IMG] I want help in generating the data for the last two columns. Dates Worked Normal OT should tell which are the days a certain employee stayed back for OT on a weekday. So for example for Bob, this column will...

I need help with this formula, it's above my skill level. I've worked on this for hours.... [/IMG]

Hi, A colleague recently returned a workbook to me where she had added additional sheets, the file is now enormous 25MB. There is no code nor extensive logic, it is primarily SUMIF functions. I have worked through the sheets and cleared the contents of all unused cells, I have checked the...

Hi Everyone, I'm new at this. Can someone help me in creating a code to Auto Sort the Data based on the Column F as soon as I type new info. Thanks in advance for any help, Jose. <tbody> Weigh Station Operators Shift Days Worked Pieces Processed Total Hrs Worked Pieces Per Hour DA...

Guys, any chance you could give me some pointers? I have copied the below formula from another work book, where it worked fine. However it keeps returning a #Div/0! error in my new work book...

Hello, I built a pivot table with several measures that key off a single date, for which I created a disconnected table on a tab in my workbook with one column and a single date value. The purpose being, I update that one date periodically based on the period I want to evaluate. Probably a...

I have a column (I) that has Dates in it (1/5/2017, 2/15/2018, 5/1/2017....) My other two columns (F & N) have peoples names and hours worked each day I want to sum by person how many hours they worked each month. How can I do this? Thanks for the help!!