Calculating the number of 15 min increments between two dates and weeks

**JosieJosie02** · 07-26-2022, 12:54 PM

I can't figure out what I am doing wrong, 2 different answers.

Can someone please help me?

I have a start date and end date, Hours/Per week, the number of weeks between the start and end dates, the number of months, and a total.

Number of days is calculated =DATEDIF(A2,B2,"D")

Number of weeks is calculated =WEEKNUM(D2)

Number of months is calculated =DATEDIF(A2,B2, "M")

Number of 15 min increments for number of days and weeks is calculated =(C2*4*E2)

A B c d e f g h i
6/1/2022 5/31/2023 24 364 52 11 15 Minute 4992 correct hours/week but wrong total
6/1/2022 5/31/2023 23.079 364 52 11 15 Minute 4800 Correct total but with wrong hours per week

**alansidman** · 07-26-2022, 01:05 PM

crossposted: https://www.mrexcel.com/board/thread...weeks.1211698/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

**JosieJosie02** · 07-26-2022, 01:09 PM

Hi Alan,
I thought I was on two different sites.
I apologize I didn't mean to post the same thread twice on the same site.

**alansidman** · 07-26-2022, 01:19 PM

Josie,
You are on two different sites. Read the highlighted link in my post above on why this is not a preferred method of seeking responses.

**MrShorty** · 07-26-2022, 02:04 PM

I'm not sure what the question is. If you have 24 hours per week (96 15 minute increments per week) and 52 weeks, 52*96 is 4992. I don't see anything wrong with that calculation. If the correct answer is supposed to be 4800, then you either have fewer hours per week, or fewer weeks per year, or there is something else missing from your description of the calculation.