regular

Hello. I have been going thru the payroll videos and I was trying to see if there is a video on shift premiums? Unless I missed it, maybe? I want to find a formula where a special shift premium is added to the employees pay from 7:00 pm to 1:00 am. The employee may actually start their shift...

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...

Hi Everyone, I'm trying to get a cleaner formula to label any records shipped as backorder. Here's my formula, but know there has to be something cleaner. =IF(AND(B2=B1,C2<>C1),"Backorder",IF(AND(A1="Backorder",B2=B1,C2=C1),A1,"Regular")) Formula: if Order# is the same as previous Order#, and...

regular sum = <tbody> 25,647,308,807.4172 sumif = </tbody> 25,647,308,807.4171 number formats are the same...i take the difference between the two numbers to several decimal places....Excel says "0.000000000000..." i check to see if they equal each other by A1=B1....excel says...

Hello! I have a problem with an excel sheet for work. Hope you can help! I have to order employees by their entry time to work, and also by their role inside the company. So, for example: <tbody> Colum A Colum B Colum C 1 Matt (regular employee) 07:00 15:00 2 Philip (supervisor) 07:00...

Hi everyone, there is a large amount of orders I receive everyday which Needed to be recorded into the master file, in contains of different category of course types. Is there a way that could look up the regular courses and copy the whole row down, and whenever new courses are registered...

Hi I have been trying to figure this out for weeks. I need my total daily hours in my regular hours column to only calculate up to 40 hours then anything over 40 hours to total in in the overtime cell. Right now it just totals the total work hours worked for a day in the regular hours, but I...

I am working on a timecard worksheet that calculates the time worked between the start time and end time. I can get it to calculate and round to the nearest quarter hour, but I also want it to max out the regular hours at 12.25 hours than its OT. This is what I have so far that I'm using and...

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="path" & Firma & "\Offers\" & "OBR1_" & broj & "_" & Firma & "_" & Format(Now(), "dd.mm.yyyy") & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False path is juts your regular...

Is there a standard practice for preparing and sending workbooks so that the recipient can't dig around in the queries? My initial thought is to just delete the queries because the static result is the objective. My concerns: 1. Forgetting to delete the queries, and sending the file off. 2...

Hello all, Here is what I am trying to accomplish - Auto populate overtime hours to another column. Here is the breakdown in writing - IF what is in this cell is GREATER THAN 40, REMOVE the amount that is GREATER and MOVE it to another column. I currently have a "REGULAR TIME" and...

Hello, I am trying to figure out how to make a spreadsheet that can calculate my gross pay. I get a base pay along with zero or one of three shift differentials, depending on when I work. An example is below. What I have right now is a spreadsheet with my clock in and out times, the amount of...

I have merged cells in column A - imagine my name merged down from A1 to A3. Then I have data in B1, B2, and B3. On another sheet I have a vlookup that's looking for my name. A regular vlookup finds my name in the merged cells and returns the value from B1. But how do I write a vlookup that...

I'm trying to do a nested IF statement but also include an IF(SEARCH) in the same formula. <tbody> A B C $15 $1000 ? $25 $100 ~$30 $75 </tbody> For example, Column A will occasionally include ~ for dollar amounts that are estimates. In Column C I'm trying to solve for the following...

I have text in B1 = : 2 myrext: take and :test In c1 = 2 d1 = take ,e1 =test This is my pattern .pattern ="^[:]([^:].+?\s)$" What wrong with my pattern in regular exspresion

Hi folks, See this as a cry for help from a noob, hoping you can help me with the following VBA/Macro question I am trying to piece together a macro which will copy data from a pivot table into a regular table at the click of a button Source: Worksheet name: Import_Skill Pivottable name...

I have a file that creates barcodes in a specific format. The trouble is, you can only make 24 at a time before you have to print them. I'd like to have a way that you can crate as many as needed and, as the sheet fills up, another sheet gets created and so on... You scan on 'Scan Sheet' It...

I’m pretty sure that manipulation of the SUMPRODUCT function will solve my problem…but I can’t figure out what that manipulation is. So here’s my question: Is there a way to calculate – within a single cell – a multi-dimensional (i.e. multiple criteria) product of a range of values when the...

Hi, Currently i have a hyperlink in my excel file connected to a Word file. When i press this hyperlink my file automaticly opens in Word. Now i want my file to open in Word-Mobile instead of regular Word. (i need the camera function) Is there anyway i can do this? is there a macro i can write...

Hi All, I use SQL to export oracle transactions to a text file which are separated by the "~" tilde delimiter. Come to find out folks use the tilde in the journal descriptions, which, of course, means I would have faulty data upon importing those text files to another db. I have since updated...