thu

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...

<tbody> <tbody> Day Descr2 Name Start time End time 6:00 - 7:00AM 7:00 - 8:00AM 8:00 - 9:00AM 9:00 - 10:00AM 10:00 - 11:00AM 11:00 - 12:00PM 12:00 - 1:00PM 1:00 - 2:00PM 2:00 - 3:00PM 3:00 - 4:00PM 4:00 - 5:00PM 5:00 - 6:00PM 6:00 - 7:00PM 7:00 - 8:00PM 8:00 - 9:00PM 9:00...

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 there Am hoping someone could point me in the right direction with a quick one. I have a list as below, and am looking to return the smallest or largest value by day: A B Mon 154 Tue 192 Wed 216 Thu 147 Fri 126 Sat 98 Sun 48 Mon 52 Tue 69 Wed 210 Thu 99 Fri 137 Sat 104 Sun...

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...

Hi everyone, is there a way to add comments based on dates? I have a file with three sheets. The first is called "2018" and is used as a calendar for year 2018 and other data. The second is called "2019" and is used as a calendar for year 2019 and other data. The last one is called "'Events" and...

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...

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...

We purchased a time clock, and the time clock company supplied us with a macro that total the daily hours as well as the total hours for any date range that we choose. Our company policy is if an employee works 6.5 or more hours per day, we subtract .5 hours from that days hours for lunch. I...

A B C <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Date Thu 05 Apr Fri 06 Apr Sat 07 Apr Sun 08 Apr Mon 09 Apr Tue 10 Apr Wed 11 Apr Thu 12 Apr Fri 13 Apr Sat 14 Apr Sun 15 Apr...

hi I am currently using this formula to calculate net pay. it only works on the first row cells. When I change to cell range it don't calculate properly. =(AF12+AG12)*Rates!$F$5-(((AF12+AG12)*Rates!$F$5-(11500/13))*0.2)-(((AF12+AG12)*Rates!$F$5-((157*4)))*0.12)-10 Snap of spread sheet...

I have the following information that I want to use to populate an excel monthly calendar <tbody> stake out Mon, Oct 02, 17 0 Mon, Oct 02, 17 excavate Tue, Oct 03, 17 2 Thu, Oct 05, 17 layout/pour footings Fri, Oct 06, 17 2 Tue, Oct 10, 17 weaping, drain, rock/gravel Wed, Oct 11, 17 1...

I have searched and looked all over the internet and this site but can't figure out how to make this work. I was given a tracking spreadsheet that I want to automate counts. Each row has the 14 days of the 2 week payperiod beginning in D9 through Q9: <tbody> SUN MON TUE WED THU FRI SAT SUN...