tue

Hi everyone, Hopefully this can be done, and hopefully you follow what I'm trying to do. Sheet1 (for argument sake, columns = A - G, rows = 2+header) <tbody> LAST FIRST MON TUE WED THU FRI Jones Bob 5 5 5 5 5 Smith Ann 8 8 8 8 8 </tbody> Sheet2 (just references from sheet1...

Hi again, i am trying to copy a alphanumeric "name" from column A to my source workbook. These names are the usernames of people responsible for particular shifts. <tbody> #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align: center"] #FFFFFF[/URL] , align...

Hi I have a column like the one below. I want to have another column beside it and each friday in column A will have number in column B as below. Is that possible to do it? Thank you very much. <colgroup><col></colgroup><tbody> Tue, 20/08/19 Wed, 21/08/19 Thu, 22/08/19 Fri, 23/08/19...

I'm working with call center data. I have call volumes for multiple groups by date, using the TEXT function to return the day of week. Like so: 06/03/19 Mon Group1 1000 06/03/19 Mon Group2 1400 06/04/19 Tue Group1 1100 06/04/19 Tue Group2 1500...

Hi Everyone I Have a sheet called "Mon Wk1" That I need to copy to make every day of the week and for Wk1 - Wk5 so for example: "Mon Wk1" "Tue Wk1" all the way to "Sun Wk5" Please help if you can Thanks Tony

I need a way to have a cell be NULL if it is Sat or Sun I did find a formula to do this, but then it won't SUM the row and/or column <tbody> Site US1787377 Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Monthly...

Hi Guys, I have the following times of duty for our employees. What I would like to do is count the maximum number of employees that will be on site during the day. Can someone please help me? There are different employee number for different days. Data below shows 4 of the days. The actual...

I need a formula that looks at the two columns below and gives me the result "Wed" as the max value Mon 10 Tue 15 Wed 20 Mon 15 Tue 10 Wed 20

<tbody> 2018 CFL's 2018 balance 2019 balance <tbody> 8-Feb-2019 2018 CFL's 2018 balance 2019 balance Jan-19 Feb-19 1-Jan-19 2-Jan-19 3-Jan-19 4-Jan-19 5-Jan-19 6-Jan-19 7-Jan-19 8-Jan-19 9-Jan-19 ID Name P L A C T CL P L A C T CL Tue Wed Thu Fri Sat...

Hello, I try to find formula in column C to calculate time based on shift patterns that could be different. Sometimes shifts can be 8 hours per day, or it can be day off in the middle of the week, because of bank holiday. Please see below data. in column C are results. C2= 13.5 hours...

I have kept a personal exercise log for many years and I am trying to keep myself motivated (extract below). Column A12 contains consecutive dates exercised from 01.01.1999, and a row is added to this for every new day. Column B12 contains exercise activity. Mon, 8 Oct 2018 OTHER Tue, 9 Oct...

Hi everyone, I'm sure this is simple but I can't find the solution online. Is there a way I can use a MID formula like this that follows this, unless there is a space, in which case it stops earlier? I have text, for example: <tbody> Tue, Jul 31 09:38:21 BST 2018 and Tue, Mar 6 14:26:37...

Hello, I'm hoping that someone can help if possible please. I have created a tracker for tasks performed across our department. Each month has 5 rows (but this can increase depending on how many tasks come in) and the days are listed across in the columns. Each year, we have to re-set the...

<tbody> Task Start date End Date No of Days Preparation Mon 30/07/218 Mon 06/08/2018 5 Blueprint Tue 07/08/2018 Tue 07/08/2018 1 Realisation Wed 08/08/2018 Fri 10/08/2018 3 </tbody> Hi Gurus, In the absence of Microsoft Project, i'm trying to make a timeline based on...

Hi All, I'm looking for a Date(in text format) to convert from PDT/PST to IST using Excel/VBA. Kindly help. Thank you. Example: "Tue Jun 30 11:30:00 PDT 2015" Result: "Wed Jul 01 12:00:00 IST 2015"

hi can any one help please, really stuggling to get this numbering to work, i have a list of wagons days leaving and need to order them with numbers counting, wagon leaving sum needed to auto count according to time leaving like...

Hello, I'm working on a project management spreadsheet and having 1 issue, automating % done. I need the sheet to look at the column A, "WBS", and calculate percentage done based on sub-tasks within that project. For example, 1 = Product Development, 1.1. = Need Development, 1.1.1 = Reviews...

i NEED HELP TO LOOK UP BASED ON CRITERIA 1. NAME 2. DATE RANGE FILES : TIMEDB AND PAYROLL <colgroup><col><col><col span="2"></colgroup><tbody> NAME DATE TIME IN TIME OUT YOGHESRAJ A/L PERUMAL May 2, 2018 8:00 22:00 YOGHESRAJ A/L PERUMAL May 3, 2018 8:00 22:00 YOGHESRAJ A/L PERUMAL May...

Please help! Is there a formula that I can put into cell E5 that calculates... for cells E2:E4 if E=1 and D="" then B*C, and then returns the sum in E5? Cheers! <tbody> A B C D E F 1 person Cost % mon tue wed 2 aa 20000 10% 1 1 1 3 bb 30000 20% 1 1 4 cc 10000 30% 1 5 Cost...

Hello. I am seeking a formula that will recognize a date in one cell and show the week of the month it is in another cell. Please see the following examples- thank you, Michael. Date range 1-7= Week 1 Date range 8-14= Week 2 Date range 15-21= Week 3 Date range 22-31= Week 4 <style...