start

The goal: In excel, determine hour by hour how much I am paying in labor versus how much we make in sales during that hour. Tables: Timesheets: Simple employee name, start time, stop time, date Timesheets EDIT (separate table): unpivoted start and stop time. Now I have a column called shift...

I need to create a gantt chart that will draw horizontal bars when I enter start and finish dates. The user would enter the item description, start date, and duration (in work days). Questions: - To get the finish date...I add the duration to the start date. How do I format the resulting...

hello everyone, I have data for various vehicles/trips and i am attempting to show the start date (data i have) and the end date (data that is not provided). I can show this if i can make the connection between the vehicle numbers and populating the start date for the next trip as the end date...

Hi all, I've managed to stump myself on what should be a fairly simple task. I have a data file with activity by time for employees. Each action has a time next to it. I'd like to create a chart that visualizes the breaks between actions so that one can see for example that someone took a...

I have a conundrum. I am using the Networkdays formula with a start date of 8/28/2018 and an end date of 6/18/2019 with the following holiday serial dates (n=28): =NETWORKDAYS(G1,H1,B3:B30) 43346 43353 43362 43381 43416 43425 43426 43427 43458 43459 43460 43461 43462 43465 43466 43486 43514...

Hello Excel experts, I have been running around to find a solution for making several cells in different sheets mandatory to fill. The excel will be sent to third party to fill and send back, I would like to avoid email ping pong to ask for missing cells, below is the code I am using and it...

<tbody> NAME LINE SUN MON TUE WED THUR FRI SAT LEE 1 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 4:30 13:00 OFF OFF OFF OFF JOHN 2 4:45 13:15 4:15 12:45 4:15 12:45 4:15 12:45 4:15 12:45 OFF OFF OFF OFF JAMES 3 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 6:45 15:15 OFF OFF OFF OFF...

Hello, I have two dates and an amount field, I want to break the revenue into each month. I have a formula =(IF(AND($B2>=D$1,$A2<=DATE(YEAR(D$1),MONTH(D$1)+1,0)),MIN($B2,DATE(YEAR(D$1),MONTH(D$1)+1,1))-MAX($A2,D$1),0)/($B2-$A2))*$C2 It breaks down the revenue incorrectly across the months. I...

Hello all! I have a spreadsheet at work that the techs enter in on/off times for equipment. I need to know how many hours the equipment has ran that day. <tbody> Date Initals OFF ALL DAY? ON ALL DAY? INITIAL SHUT DOWN INITIAL START UP SECONDARY SHUT DOWN SECONDARY START UP 5/1/2019 BB...

I'm trying to create a chart using conditional formatting that will show the hours that each employee is working. I have a formula for that works for Chris' time but can't figure out a formula that covers both Chris & Richard's schedule since Richard is working overnight. Richard's hours...

I have several buttons on on work sheet. At some point, they decide to start resizing themselves. AN internet search seems to indicate this is a common problem. I am not married to command buttons is there an option for these macros that would avoid the automagically resized buttons. Ian

Hello, I have a list in column A in an Excel workbook called "Pipe Sizes". I want workbook "template" to read A2 and assign "job no" to value in A2. Run "start" macro. At end of "start" macro, assign "job no" to value in A3 and run "start" macro. So on so forth until it hits an empty cell...

I have a sheet that contains start times in column A and end times in column B. I have another sheet that I would like to pull the start time and end time into one cell for ease of printing. Like this - 8:00AM - 5:00PM When I use the following formula - =sheet1!A1&" - "&sheet1!B1 it pulls...

Good morning :) I've been looking all over for a macro that does what I need, but I have been unable to find one, so I will appreciate ANY help someone can offer. I have a report that has about 150 rows and 9 columns. One of the columns is "Start Time". Every time there is a change in "Start...

Hello, I use this formula =DATA(M2;D2;1) and this one too =SE(H6<>"";SE(MÊS(H6)<>MÊS(H6+1);"";H6+1);"") to retrieve the start date and the end date of the month. How can i make it start on day 25 and go till day 26 of the next month since the formula hides the days if the months has one day...

Hi All I have large data set that appears like this sorted Date - Name - Code - Start - End 01/01/2018 - A - Work - 08:00 - 13:00 01/01/2018 - A - Lunch - 13:00 -13:30 01/01/2018 -A - Work - 13:30 - 16:00 01/02/2018-A - AL - 08:00 - 12:00 01/02/2018 - A- Lunch - 12:00 - 12:30 01/02/2018 - A -...

Thank you to anyone who can help me. I need to insert 4 blank rows every time there is a value change in column B. AND, if you're feeling happy, I'd actually like to insert 5 rows...4 blank ones and the 5th being a copy of the header row. The copy of the header row needs to be exact..same font...

Hi Everyone, Hoping someone can help with this, I would like to input a start date and durration and get 4 dates equal weeks apart from that info. So for example D2= Start Date, (I input 01/July/2019) D3= Duration in weeks (I Input 4 weeks) So I would get the following dates in range...

Hi, and thank you for any help and assistance. My spreadsheet has 5 columns and about 200 rows. One of the columns is Name, then Start time, another is end time, a 4th is location, a 5th is role. Initially, I sort by start time and then every time there is a change in start time, I have to...

Hello, My employees work on multiple projects, they use excel to record their hours. We currently have 10+ projects but an employee may only be working on any 5 of those. Each employee has their own excel spreadsheet (stored on sharepoint- online 365) I would like to be able to...