break

I am a bit confused with regard to the Lifetime and Scope of variables. Given this code: Option Explicit Dim a As Integer Sub FromSheet1() Sheet3.Select a = 1 End Sub Sub FromSheet2() Sheet3.Select a = 2 End Sub Sub GoBack() If a...

Hi! Thank you for your kind time. Can you please help with a VBA code that page breaks the rows of sheet "Report". A. PB Every 35 rows. The rows range is Row 1:600. B. If the row that will have a Page Break has data in the C column (current row). The page break will take place in the upper...

Hi Experts, Need your help on creating a calculated field in MS access query. I have 3 Tables Headcount, Attendance & Break data, Training & Meeting Headcount table has staff wise date and shift intime against which i need the staff wise date wise available hours and Break hours duration...

Need to sum and multiply in a time sheet style formula and ignore text =SUM((K26-H26)+(I26-J26))*24 Columns are Time In, Time Out, Break in, Break Out I'd like to put either a - or n/a if they do not take a break and then sum their hours.

Hi. there are lots of videos online teaching gantt chart with scheduling (by hours and minutes). but I haven't found anything about inserting break hour (lunch hour) Is this doable? can anyone guide me where to find it? Thanks

Hi Why this formula is working =IF(ISERROR(VLOOKUP(A2,B:B,1,FALSE)),B2,"") I tried to use Iserror(function) without second argument and excel did not accept that but the above function works! can you please break it down. I tried to do it myself and never get it work! thank you. Source...

Hi. I have a column of monthly total costs & a column of monthly total takings from a vending machine our social fund has. Can anyone suggest a formula that could predict the date of break even? Regards

I have Excel 2016. Occasionally I have a difficult time breaking external links. My process is as follows: Data - Edit Link - Break link. If link is not broken then I delete any "named" ranges referencing an external files, and then Data - Edit Link - Break link again. Most of the time this...

Hello guys I am working on a break schedule for work and I am have a hard time with it I need to take the employee start work time add 2 hours for their first break 4 hours for their lunch and 6 hours for their last break. also I need it to look to see if there is anyone else on break at...

Hi, Can anyone please help me. I want to auto deduct break from total working hours base on several situation. 1) Monday - Friday - 0.5 for =>3hours - 1.0 for =>6hours 2) Saturday - Sunday - 0.5 for =>6hours - 1.0 for =>8hours 3) Public Holiday - 0.5 for =>6hours...

I was going to develop a UserForm but decided that just adding a ListBox to the Worksheet would be simpler. I have a decent reference book to help me but I'm finding it is a bit outdated. I've placed my code below. The first line does not allow me to go into Break Mode. So I can only debug by...

hi, I have datetime in cells A1:D1 A1: 2018-12-03 06:00 (day work start); A2: 2018-12-03 10:00 (breakfast break start); A3: 2018-12-03 11:00 (breakfast break stop); A4: 2018-12-03 15:00 (day work stop); So normally this is 9hrs work day with 1hr break included. The workers are payed for 8hrs...

Hello I need an if then or else statement that will check an https:// SharePoint url to see if a file exists. If it does, then a msgbox that will ask if you would like to overwrite. If not then exit Sub. The problem I'm experiencing here is: Url access to SharePoint does not require a...

Good afternoon everybody I have a very large table (14000 rows) of contract data, an extract of which I've simplified here. Each row in that table has a contract identifier ("ID") which may or may not be unique, depending on the complexity of the contract. Within each row, there may or may not...

Hi, Is it possible to terminate a pop-up message box, by using something like Ctrl + Break, without clicking on "Yes", "No", "Cancel" etc... buttons ? I have a command button on an userform. When it is clicked, a message box would pop-up. However, pressing Esc / Ctrl + Break seem not working to...

Can we set page break in access if yes kindly guide about it Thanks in advance ?

I have a large multi column address data base i would like to break down into county groups by loading in lists of the individual municipalities. how do i write a reusable function/formula in excel that mimics this query? "city" contains Arkport OR Atlanta OR Avoca OR Cohocton OR Dansville OR...

Hi The code below is to clear the whole sheet except the first row. Rows("2:"& Rows.Count).ClearContents I am unable to understand it. I would appreciate it if you can break it down so I can understand the logic behind it. Thank you so much

Hi All, I am looking for some assistance with developing a formula to break up a cell into multiple columns. I have 4 lines to the cell. i need to combine line 1 and 2, break up line 3 into 3 separate cells and then delete the 4th line. I am looking for a formula as I am working on a template...

I am trying to utilize a break gap spreadsheet and add conditional formatting to it to highlight when an employee takes their break within a window of time and for the CF to color highlight anyone outside of the specific threshold of time. example: employee's 1st break is scheduled at 7:00...