# Calculate days needed from month to month

1. ## Calculate days needed from month to month

Hello All,
I have a challenge using the right calculation when the planned days go from one month to another month.
Some background info, we have cars driving around in NL doing mapping work (we basically film and photograph all roads and everything around the roads).
In order to do this, we need clear weather and sunlight. In April we have less sun hours as we have in May.
My problem is, when we start with a new municipality on APR/27 and we need 6 days to cover this municipality, part of the days are in APR and part are in MAY.
However in May we should calculate with more sun hours as in APR, as our production (KM per day) is higher in MAY.
How can I use the days for APR with details of APR and days in MAY with details for MAY?
See attachment, it's without formula's as I simply don't know the formula how to do this?

2. ## Re: Calculate days needed from month to month

Need with expected results enter manually

3. ## Re: Calculate days needed from month to month

Originally Posted by avk
Need with expected results enter manually

4. ## Re: Calculate days needed from month to month

I looked on the site below and it showed that on April 27 Enschede will recieve 14:42:43 of sunlight. On May3 it will recieve 15:04:31 of sunlight.
So that is only a difference of 0:21:48 and an average of 14:53:37 of sunlight hours per day.
The worksheet seems to indicate that there will be seven productive hours in April and ten in May.
I don't understand how those numbers are derived, but I don't feel that there will be that large of a jump in productive hours over the course of six days.
It may be that an average number of productive hours between the start and end date would yield a more accurate result.
Let us know if you have any questions.
https://www.timeanddate.com/sun/neth...th=5&year=2024

5. ## Re: Calculate days needed from month to month

Using the information on the spreadsheet attached to post #1, I populated cells X14 and down with the following to get the average number of productive hours per day:
Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1