regular

I am trying to create a time sheet that calculates regular time up to 8 hours, overtime after that and double time between midnight and 6 am. After 6 am the time returns to regular time. Also double time happens after 12 total hours of work Any help would be appreciated!

Just expressions, I've learned about Regular properties and methods ABCDEFGH1PlayDateN1N2N3N4N5MballPlayDateTicks22020-11-03731444555196373995840000000003.............4.............5.............67 There is no need to consider line feed

Hi Please I need your help to understand Advanced filter. In the example below, the author said to use advanced filter that means to use OR condition. and he created the criteria and found this I understood all the above but what I do not understand, when I use a regular filter to filter...

Hi, I am new to MS Access and have never used Class module in Excel VBA either. My question is more regarding Access, can anyone please help me understand what are class modules. How they are different from regular modules. What are the advantages of a class module or why and when should we...

Hello Everyone, I'm getting some odd behavior when I try running some VBA code that updates the font type in a page header. Here is the snippet of code: With masterWkbk.Worksheets("Dashboard") .PageSetup.RightHeader = "&""Times New Roman,Regular" & Format(Now, "YYYY") & " " & prevQtr &...

I need a formula that will look at the dates in a column and if between X and Y then sum(range) I am working on calculating quarterly totals, so I want it to look in colA for date between 01/01/2019 and 03/31/2019 then add that range totals from column E col A Col B...

Please help! I am struggling so bad! I am trying to run 4 potential values. C11 can contain "Mini" or "Regular" Mini = 5.50 Regular = 6.50 BUT If H11 contains "Lays","BBQ","Doritos", then add .50 to total. So if they select one of those options, the total then becomes 6.00 for a Mini &...

I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. instead of looking at July or August, look at Year Total)? The problem is the aggregated number...

Hello, I'm looking for a formula that will multiply a value based on the time codes of Regular (no multiplier), Overtime (1.5 multiplier) and Premium(2 multiplier). The download from our accounting software displays as follows: <colgroup><col><col></colgroup><tbody> Type Hours...

Hi, I have a query related to SUMPRODUCT with multiple criteria in Rows and Columns. Using the below example to explain the problem. I have data of sales figures of various products belonging to different categories for different quarters over a few years. Am trying to calculate the...

Hello,</SPAN></SPAN> For now using in the cell C5 following formula, is there any replacement of this non-volatile formula to regular formula </SPAN></SPAN> Book1ABC1231245126172839510611101212134014601565167217381861Sheet2Cell...

Hi - I know how to do this with VBA, but is there a way to do it with a "regular" formula. So something like if C1 = 27 the Formula would be sum (A&C1:A100) which would sum A27 to A100.

I posted this a few weeks ago, as i was working with the data, i noticed that some of the hourly calculations were not correct. To shed some light on this, here is what i am trying to do: I have the following headers: A=Payroll Company B=Code Payroll Name C=File Number D=Payroll Pay Date...

Im trying to build a way, how to derive from overtime hours regular working time. The rationale is that the regular working hours would be clearly visible. Example: I enter overtime work info 18:00-21:00 (3 hours), and excel calculates that work start time must have been 09:30 and end time...

So I have a data set that I import off of a website. The positive numbers look good. But this minus sign is double the size of a regular negative. Website value: –0.13% Regular value: -0.13% I've tried to do find and replace, but that doesn't work. The problem is, I use the copy / paste...

Hello guys, I have a matrix with some measure columns that creates some conditions. That´s the Delta_classification. Delta_classification =...

Hi, I'm putting together a timesheet for my company and I'm having a bit of trouble doing hour totaling. On the same sheet I have rows for different job numbers and columns for days of the week. I also have 2 sections on one sheet, one relating to regular time worked and one relating to hours...

Hello, Trying to loop through the B column and when there's a certain string I want to enter a fixed value in column H, but when it's case REGULAR DELIVERY PV I also want to add the value of the j column to the fixed value. I know I need to do an offset but my code doesn't seem to work. Please...

Hello, I'm trying to do a case statement in VBA. If the value in J is >= 200 AND <300 I want it to say in O REGULAR DELIVERY PV, when >= 300 AND <400 I want it to say REGULAR DELIVERY PV300, and when >= 400 REGULAR DELIVERY PV400. This does not work. Sub VolumeChange() '...

Hello, I created groups in my regular pivot table, but now I want to create a power pivot. Is there a way to carry-over my grouping from the regular pivot table into the power pivot without recreating it? Thanks, RCAAA