Excel formula to take time off from a time range
I am trying to get Cell D2 to give me a result based on the result in C2. I have 4 different time "zones" Each time slot has an amount of time taken off so if the employee starts at 7am and finishes at 11am they would be in the system for 4 hours. On 4 hours they get a 15 minute break and so will only be paid for 3 hours and 45 minutes. the formula works fine with one instance but as soon as I string the rest it goes hay wire. Any help / advise would be greatly appreciated. The formula I am trying to run is as follows: =IF(AND(C2>=TIME(4,0,0),C2<=TIME(5,59,0))*C2-TIME(0,15,0),AND(C2>=TIME(6,0,0),C2<=TIME(7,59,0))*C2-TIME(0,30,0)*AND(C2>=TIME(8,0,0),C2<=TIME(8,59,0))*C2-TIME(0,60,0)*AND(C2>=TIME(9,0,0),C2<=TIME(11,59,0))*C2-TIME(0,90,0))
VBA trouble with Export as Fixed Format
Hi folks - I'm struggling to get this code for export as fixed format to work. My aim is to use it to churn through 150 names in a dropdown (data validation using a reference to a named range called "Names") and print PDF earning statements for each person. I have the file stored on Sharepoint and when I run it there it seems to churn through the names, but not produce the PDFs (at least not that I can find). When I move the file to my local device (Mac), it throws an error and highlights this part as the issue. Any help is most appreciated. I'd also love to learn how to fire this from the version hosted on Sharepoint, but from this article it seems I'll need some more VBA. Sub PrintAllVariablePayoutPDFs() Dim DropDown As Range 'xRg Dim IndivName As Range Dim NamesList As Range 'List of COMPANY Employees Dim PDFName As String Dim PDFPath As String Dim FullPath As String ' Turn off screen updating Application.ScreenUpdating = False ' Set where dropdown resides Set DropDown = Range("G2") ' Set where list of names resides Set NamesList = Evaluate(DropDown.Validation.Formula1) ' Set PDF path every quarter PDFPath = "/Users/dominiccronshaw/Library/CloudStorage/OneDrive-COMPANY/GTM Operations/Commissions/2025 Q3/Payout PDFs/" 'Set PDFName PDFName = Range("K4").Value ' Construct the full file path ' FullPath = PDFPath & PDFName & ".pdf" 'Steps through options in the dropdown with people's names For Each IndivName In NamesList DropDown = IndivName.Value 'Prints each sheet as PDF with unique file name ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ FileName:=PDFName, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False, _ OpenAfterPublish:=False Next 'Turn on screen updating Application.ScreenUpdating = True End Sub
Titre axe secondaire
Bonjour, j’utilise Excel Microsoft 365 sur Mac et je rencontre un problème avec mon graphique de la loi de Pareto (voir capture d’écran jointe). Le graphique combine des colonnes pour le chiffre d’affaires et une courbe pour le pourcentage cumulé. Mon souci est que je n’arrive pas à ajouter un titre à l’axe vertical secondaire (celui de droite, qui affiche les pourcentages). L’option “Titre d’axe secondaire” n’apparaît ni dans le ruban, ni dans les paramètres du graphique, même quand j’active l’axe secondaire. J’ai déjà essayé de passer par les menus contextuels, les options de graphique, et même de modifier le type de graphique combiné, mais sans succès. Pouvez-vous m’aider à afficher ou activer le titre de l’axe secondaire ? Merci d’avance pour votre aide !
How to make excel add or remove rows to fit data and prevent spill error?
Hello! My question is: When using the =FILTER formula to copy cell data from one sheet to another, how can I make excel add or remove rows as needed to prevent a spill error? I am using the =FILTER formula to copy cell data from one sheet to another if a checkbox is checked. My formula uses the cells containing the checkbox (column A) as the reference for columns B, C, D, etc. to the right. I did this by selecting the cell that has the formula on the destination sheet, highlighting this cell and those to the right I wanted to transfer, and then control + r. My formula is: =FILTER('Source Sheet'!B5:B13,'Source Sheet'!$A5:$A13=TRUE) (If there is a way to copy an entire row from the source sheet instead of having to control+r to apply the original formula across select cells please also let me know, thank you!). However, I want the sheet to be able to automatically add rows to fit the data if the selected number of rows is greater than what I have left available on the sheet. Currently, if I leave 3 rows for data to fill and I select three checkboxes, this will fill the space with no problem. However, if I select 4+, I get a spill error (as there are not enough empty rows to put the data). Is there any easy way to have excel add rows as needed? Similarly, is there a way for excel to remove rows as needed? I am going to use this sheet to detail all medications being taken by family members (with medication name, concentration, dose, time to take each in their own column as column B, column C, column D, column E). The names will be listed in column A with ~3 rows below each name which will fill when the checkbox on the source sheet is clicked. I want to ideally fit this on one page when printing without major "fit to page" problems that come up during printing. The layout of the sheet will ideally look like this: The goal for the 'destination sheet' is to pull only the selected data I want to use from my master list on the 'source' sheet.' I want to avoid having a big empty space under each family member where they don't take many medications, and to also not have to manually add rows for family members that take a greater number of medications. Please let me know and thank you!
Pivot table
having an Excel workbook with multiple sheets. each contain certain data and a pivot table in each one. recently started having problem that is when I copy a pivot table from an existing data sheet to a new inserted sheet and then changing the source of data to the new sheet and then refresh the pivot table then save and close the file; then when I try to open the file again I got an error and the most recent pivot table get deleted. tried several ways to solve the issue with no avail noting I'm using Microsoft 365 for Mac. appreciate any helpExcel for Mac Character entry into cell delayed til after all return entries processed.
MBA M2 Sequoia 15.6.1 (24G90) Excel Version 16.102 This issue started after recent update. When there is a big resource demand entries into cells used to be delayed, but would run correctly when resources were available. For example: Select cell A1 Type "A" Return Type "B" Return Type "C" Return This would produce A, B, and then C in three separate cells down the column, even when resource demand was high, the entries would just be delayed but entered correctly. Now, the process when delayed by resource demand, stores all the cell entries, first runs all return commands and then puts all entries into the last cell.
