•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need Tips Creating a Custom Table
Our take
Are you struggling to calculate program hours in Excel between two specific dates? You're not alone—many find themselves tangled in functions and pivot tables while trying to create a custom table. Imagine having a straightforward solution that not only tracks your group hours but also features user-friendly drop-down menus. This guide will walk you through the process of building that table, ensuring you can easily quantify your program hours without the headache. Let’s unlock a simpler approach to your data management!
Essentially, I need help creating a table in Excel that allows me to calculate the number of program hours between two dates.
I work for a treatment program that offers 5 hours of group Monday-Thursday and 3 hours of group on Friday. What I'm trying to create is a table that will tell me the total number of group hours between two dates, ideally using drop down menus.
I've really gotten into the weeds, trying different functions and pivot tables, but I still haven't cracked it. Any help would greatly appreciated. Thanks!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How do I create a table with days in the columns, locations in the rows, and program names and times in the cells?I need to create something like this image, without doing it manually (hopefully). I need the days of the week as headings on the x axis, locations on the y axis, and then program name and time of program in the cells. I've tried using a pivot table, but the values field won't show the text only calculations. There are over 5,300 events, but I need it summarized down to this to give to the marketing team. I would also like to be able to edit with additional notes if needed. Any ideas other than copy and pasting this manually into a grid? https://preview.redd.it/fk7n51pmcdyg1.png?width=768&format=png&auto=webp&s=c995a7b9f596e97036d1821acc4d61553c82fab2 submitted by /u/im_8675309 [link] [comments]
- I need a spreadsheet to know how many hours I work and how much I will chargeHello, I don't know anything about Excel or I have a PC, but well, I have the app.. but I need help, I work on demand, they call me when they need and they change my schedule.. that's why controlling the hours is sometimes cumbersome (for topics such as night hours etc.) could someone help me with tips on how I can make a spreadsheet that adds up the hours? In other words, the idea is to set the schedule I work and that the spreadsheet adds up how many hours I worked and then the total.. The criterion would be to be able to put the date, the schedule for example from 14 to 22 and that the form says how many hours there are and adds them in total, if it is possible to specify more as hours after x quantity that counts them separately (extra hours) or that the hours after a certain schedule are counted separately (night hours) I just want to put the schedules and know how many common, extra and night hours I did so I can calculate what I should charge and deduct taxes etc... I know I ask a lot and maybe it's not possible to do this in the app, if you could help me I would appreciate it. Even if no one helps, thank you anyway. If it reads weird it's because it's automatic translation... Repost translated because for some reason reddit deleted it.. although it was in English... submitted by /u/nameku9 [link] [comments]
- Trying to create an if then or if then for a drop down menuIt's been a good while since i have used excel. I'm trying to create a sheet where if you select an item say 160×60 or 160×50 then it will bring up text in another cell say 4 wheel unit or 6 wheel unit and also populate a cell with today's date. I've been trying all morning, but my brains collapsed. Cheers in advance submitted by /u/JIJOBO [link] [comments]
- Trying to create a weekly work schedule. Created a table with dropdown menu. How can I reference this table to a separate table that the value has already been chosen?Hello, I created a weekly table with a list of employee names. I also created a dropdown menu for each field of all the job types to select from. I am trying to reference this table into a different table with all the job types on 1 column so I know that it has been chosen on any given day. I was thinking it can populate with a '1' Bonus if the same job is chosen again, then it can populate a '2'. If this is not possible, then perhaps, using different colours? I will add a photo to give you an idea of what I'm trying to do. Thanks. submitted by /u/vivagayvegas [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel#custom table#program hours#group hours#drop down menus#calculate#between two dates#functions#pivot tables#treatment program#Monday-Thursday#Friday#total number#help#weeds