Excel – Flow calculation – Number of days absent within a set reporting week

First – an apology for the convoluted request. I know what I am trying to do but I’m not sure I can articulate it clearly enough.

I was a list of staff’s absences with start date and end date. I need to work out how many days of a specific reporting week they were absent for, then I need to multiply that by the number of hours they work in a day.

Examples below :

Reporting week dates
Start date 30/09/2019
End Date 06/10/2019

Absences

Start date End date

16/05/2019 20/10/2019
21/05/2019
23/05/2019
25/06/2019 13/10/2019
06/08/2019 08/01/2020
06/08/2019 08/01/2020
12/08/2019 04/10/2019

I can see that for the majority of these it would be 7 days, but since there is a 5/7 pattern, it would be 5 days. But for the last one who came back halfway through the week it wouldn’t be. But I’m not sure what the correct syntax would be on excel to achieve this consistently for every absence instances.

Any help would be very much appreciated!

Thank you

Lucy

[ Politics ] Open Question :  Covid 19 U.S. deaths dropped by over 1000 per week since April 18, why the surge in media panic?

Per CDC

Weeks ending ; 
4/18/20 , 16,360 deaths 6/13/20 ; 2,148 deaths

TMD hosting. Dedicated server down every week for 12 hours

TMD hosting. Dedicated server down every week for 12 hours | Web Hosting Talk


‘);
var sidebar_align = ‘right’;
var content_container_margin = parseInt(‘350px’);
var sidebar_width = parseInt(‘330px’);
//–>









  1. TMD hosting. Dedicated server down every week for 12 hours


    It looks like I made mistake switching to TMD hosting. The sales chat was sweet and they transferred me within 24 hours. But then… server goes down it takes them 6 hours to push the reboot button. Same month, server down again, needs to be rebooted. It has been now 14 hours and all emails are answered with the same canned reply.

    PHP Code:


    The case is investigated by our system administrators and they will update you as soon as more information is available.

    Do 

    have in mind that updating constantly one ticket or submitting multiple tickets will not speed up our working process so I kindly ask you to be patient. Considering the above we will now close this ticket


    Is that even a real company or got scammed and it’s just one dude running chat bots from his parent’s basement?













Similar Threads


  1. Replies: 0


    Last Post: 10-24-2011, 10:31 AM


  2. Replies: 7


    Last Post: 09-23-2002, 10:43 AM


  3. Replies: 2


    Last Post: 04-27-2002, 07:40 AM


  4. Replies: 0


    Last Post: 07-28-2001, 06:02 PM


  5. Replies: 6


    Last Post: 04-24-2001, 10:55 PM

Tags for this Thread



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  








I want to build a 2013 List that archives itself weekly and creates an email summary of new items since last week

My office is limited to SP 2013, and SP Designer with 2010/2013 Work Flows available. I have only rudimentary SharePoint Skills.

Problem:
We track our weekly status reports in a word document that gets over-written each week. I would like to build a SP2013 list that is populated by a form that records our weekly data.

Our current process:

A. Six middle-managers input a weekly status report to a SP-hosted Word Document

B. Supervisor reviews submissions, tweaks the wording, then copies the information to an e-mail.

C. Supervisor sends email to Boss. (Middle managers aren’t seeing what’s sent, which would be nice).

D. Process repeats with middle-managers typing over previous submissions in word document. No one archives the email, nor the retains the last week’s submissions outside of Supervisor-to-Boss email.

As our Supervisor rotates every year or two, I’d like to develop a system that archives what she sends, and allows middle-managers to see submissions.

Requirements:

  1. Multiple users can add items to this list.
  2. A designated supervisor and/or alternate has/have the ability to edit all entries, and approve those to be sent to the next level supervisor.
  3. Every Wednesday, the list generates an report / summary based off of the contents added and approved since last Wednesday. The goal is to make this as simple as possible for the supervisor, who usually copies and .
  4. That report is then archived, either by shifting the data to another list or saving the report. The goal is to provide a searchable record for the their use later on.

I can visualize a couple of different ways to do this, but don’t have the know-how to do it. Really, it’s an open space. Does anyone know how to do this? Thanks in Advance.

flatpickr first day of week Monday and shorthandcurrentMonth

I have started to use flatpickr on a form and it’s working but want to add couple of options to it. I want to add the firstDayOfWeek so that Monday is the first day of the week and then want to shorthandCurrentMonth so it shows Jun instead of June

I know the option code I have is sort of working as dateFormat: “d-m-Y”, works if I change the date format and it shows the date format I alter in the dateFormat line but unsure why the firstDayofWeek and shorthandCurrentMonth is not working, below is the code I have
SEMrush

<script>
var example = flatpickr("#flatpickr", {  
// A string of characters which are used to define how the date will be displayed in the input box.
dateFormat: "d-m-Y",
// Show the month using the shorthand version.
shorthandCurrentMonth: true,
"locale": {
    "firstDayOfWeek": 1 // start week on Monday
}
});  
</script>

Code (JavaScript):

 

google apps script – How to open sheets to a specific tab based on days of the week?

I have a file with 7 tabs or sheets each of them represent a day of the week (Monday to Sunday). In each day (Tab) a have this formula in B2 to show the day of the week if it is today…

=IF(WEEKDAY(TODAY(),2) = 1, "Monday", IF(FALSE, "True", ))
=IF(WEEKDAY(TODAY(),2) = 2, "Tuesday", IF(FALSE, "True", ))
=IF(WEEKDAY(TODAY(),2) = 3, "Wednesday", IF(FALSE, "True", ))
=IF(WEEKDAY(TODAY(),2) = 4, "Thursday", IF(FALSE, "True", ))
=IF(WEEKDAY(TODAY(),2) = 5, "Friday", IF(FALSE, "True", ))
=IF(WEEKDAY(TODAY(),2) = 6, "Saturday", IF(FALSE, "True", ))
=IF(WEEKDAY(TODAY(),2) = 7, "Sunday", IF(FALSE, "True", ))

I would like the document every time is open to open in the correspondent “Day of the week” Tab,

Is this possible with a script?

Here is the link to the Sheet:
https://docs.google.com/spreadsheets/d/1GI2R_KI6ujxK7g_jBEpcCoLZt6Fyqngri5CP3kEJNz8/edit?usp=sharing

Can Google Calendar view six weeks with “this week” always at the top?

The company I work for just put up some Tv’s around the shop for “digital signage”. What we are trying to display is a “outlook/forecast” calendar for Shop assembly jobs so we can always see whats coming up in the next 6 Weeks. I got the Embedded code for for our google calendar and put it into a HTML document and put it on our local server. When I navigate to the “webpage” using the signage software or even G-chrome it displays 6 weeks which is what we want but the calendar always starts at the first of the month at the top. So by the time we get to the end of the months we are not able to see what is coming up, even in the next week until the month view flips. Is there a way to change the embedded code so that the top of the calendar is always the current week? If this cannot be done with google calendar is there a different embedded calendar that has this ability? below is sample of the embedded code just to a test calendar.

<iframe src="https://calendar.google.com/calendar/embed?height=600&amp;wkst=1&amp;bgcolor=%23ffffff&amp;ctz=America%2FChicago&amp;src=ZGg1NDcyczZocWlpYjZyOHQ4djlsb2Jyb2dAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ&amp;color=%23F09300&amp;mode=MONTH" style="border:solid 1px #777" width="800" height="600" frameborder="0" scrolling="no"></iframe>

How to make 50$ to 100$ per week for free doing simple task – Social Media Marketing (SMM)

Hi I’m Olivia

I have a new website that you can use to earn 59$ t0 100$ doing simple task.

The website is paying and very easy to earn it also have a referral program.

You can earn 5$ for each person you refer to the website .

Withdraw to PayPal exchange to btc or any crypto currency

Good luck.

Stay safe

http://tryvindale.com/VVvtsUmh

How to make 50$ to 100$ per week for free doing simple task – Other Money Making Opportunities

To everybody out there

I have a new website that you can use to earn 59$ t0 100$ doing simple task.

The website is paying and very easy to earn it also have a referral program.

You can earn 5$ for each person you refer to the website .

Good luck.

http://tryvindale.com/VVvtsUmh

post processing – How do I shift a series of time lapsed photos (a week between each photo) to match hardpoints?

I have collected a series of photos approximately 1 week apart using a drone. Thus, the photos are slightly different. I want to transform each photo using a series of hard points so that those points align. I don’t want to merge the photos, just align all of the photos so that they don’t “jump” around when I toggle through them. I assume I choose a base photo that I’ll match the others to and then crop them all to have the same frame size.

DreamProxies - Cheapest USA Elite Private Proxies 100 Private Proxies 200 Private Proxies 400 Private Proxies 1000 Private Proxies 2000 Private Proxies ExtraProxies.com - Buy Cheap Private Proxies Buy 50 Private Proxies Buy 100 Private Proxies Buy 200 Private Proxies Buy 500 Private Proxies Buy 1000 Private Proxies Buy 2000 Private Proxies ProxiesLive Proxies-free.com New Proxy Lists Every Day Proxies123