breaks

Struggling to make this work for me, probable cause - complete novice. I'm changing roles and now need to be looking into creating rotas, I've created my template for it, but I need to take out 15 minutes (0.25) out of each shift over 5 hours for breaks. I cheated a little and did the...

Good Morning All, I am wondering if it is possible to take the code below and add a next step. In this step i want to take the data from sheet 2 (Tab 2) and split it into two additional tabs called "s breaks" and "c breaks". So, if the cells in column "N" contain "Working with Client" or...

Hello, I'd like to automate the process of moving page breaks within a fairly small pivot table. I just recorded the following macro while I manually adjusted page breaks to my liking. Here's the code: ActiveWindow.View = xlPageBreakPreview ActiveWindow.SmallScroll Down:=-33...

I have a spreadsheet that looks like this: <tbody> Student Course John Smith English;Math;Science;History Jane Smith Math;History;Art </tbody> I would like to replace all semicolons with line breaks if possible, so that it would appear like this: <tbody> Student Course John Smith...

Hi all, I currently have a file which links into 3 other large files (in order to consolidate the data) but the issue is that they are all password protected so in order to relink to the next month's version, I end up have to open quite a few files just to do this and sometimes it breaks...

A1 is start time, B1 is finish time, C1 is B1 - A1 to give total time worked that day. Is there an easy way to auto deduct breaks in C1 as follows? less than or equal to 9 hours deduct 30 mins break More than 9 hours deduct 1 hour break All cells to be 24 hour format without : entered as 0900...

I'm currently trying to create a formula that automatically calculates a win/loss record based on increases and decreases in postgame rating. The following formula was working great for me until we decided to make changes to how we record time spent...

Hi everybody, I am new, this is my first post. Anyone can help me with the following question? Given an excel cell with line breaks (Alt+Enter or line breaks from text copied and pasted), is there a way to adjust the height of the cell so that it fits the number of text lines without wrapping/...

Hi all, I have a macro that saves to pdf and this works great, thanks to all your help Is there a way to insert page breaks depending on data in column D Column D has the headings for each selection of data beginning with "ZZ099...." Hope this makes sense Thanks

I need to determine where Excel will put automatic page breaks in a sheet where the #rows, and their heights, vary. Reading .PageBreak for every row turns out to be very slow! Is there a better way? My sheets have several sections; we'd like to avoid page breaks within a section. Rows get...

Hello, I've been dabbling with macros recently, but have not found a way to apply macros to selected sheets in the workbook. The macro I have works flawlessly on the active sheet, it applies the proper page breaks and if a certain section is completely hidden it won't print the page. Below is...

I use this code all the time but it breaks if someone renames the source tab. Any ideas? =OFFSET(tabname!$J$4,0,0,COUNTIF(tabname!$J$4:$J$65536,"> "))

I have a workbook, Book-A, that I have defined a UDF. When I open a second workbook, it breaks the UDF on the first workbook. How do I stop this? Rich

Dear all, Print related features like print preview, page breaks, page setup in page layout not working in excel 2013. But it is working in MS Word. Can you please help me with the issue? I couldn't find any solution in normal googling. Thanks, safal

Hi guys, I come to you seeking much help. I have gone way beyond my excel knowledge and have now been landed with a task which I cannot do!:confused: I want to create a Staff Rota which can calculate the following Hours worked in shift, hours worked in day also needs to deduct breaks upto...