+ Reply to Thread
Results 1 to 11 of 11

Hourly calculation over a period of time

  1. 04-03-2020, 12:02 PM #1
    soodaakash04
    soodaakash04 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    India
    MS-Off Ver
    Excel 16
    Posts
    6

    Lightbulb Hourly calculation over a period of time

    HI

    I have a dataset of x stores that stay open along with their open and closed time. A part of the data here :

    ID Zone Open Time 1 Close time 1
    40757 East Chd 8:00:00 AM 11:00:00 PM
    266110 East Chd 12:10:00 PM 6:50:00 PM
    266203 East Chd 10:00:00 AM 6:00:00 PM
    266241 East Chd 9:05:00 AM 9:00:00 PM
    126444 West Chd 9:05:00 AM 8:30:00 PM

    Now I want an hour level ZONE WISE analysis of how many stores are open between 8 and 9 AM, 9 and 10 AM 10 and 11 AM and so on...........

    So can anyone please help me out with this
    Last edited by AliGW; 04-03-2020 at 12:21 PM. Reason: Irrelevant section of title removed.
    Reply With QuoteRegister To Reply
  2. 04-03-2020, 12:04 PM #2
    soodaakash04
    soodaakash04 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    India
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: URGENT HELP NEEDED !!!!Hourly calculation over a period of time

    This is how I want my result to look like

    Zone 7 to 8 AM 8 to 9 AM 9 to 10 AM 6 PM to 7 PM
    East Chd x x
    West Chd
    South Chd
    Reply With QuoteRegister To Reply
  3. 04-03-2020, 12:23 PM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,806

    Re: Hourly calculation over a period of time

    Please note that I have edited your thread title: this is a free forum, and members help voluntarily in their free time. As the help you get, if you get it, will be for free, we do not prioritise any member's requests over any other's. I hope you understand and are not expecting to get an immediate solution.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 04-03-2020, 12:27 PM #4
    soodaakash04
    soodaakash04 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    India
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: Hourly calculation over a period of time

    Hey Ali

    Thanks for your help, I so understand and respect everyone's priorities, it;s just that I have a couple of hours left to submit the report and I am just stuck here.
    Reply With QuoteRegister To Reply
  5. 04-03-2020, 12:32 PM #5
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,806

    Re: Hourly calculation over a period of time

    Sadly that's irrelevant here. If it's urgent, maybe you should go and hire help on a paid site?

    As for this forum, you will just need to wait patiently and hope someone can help.
    Reply With QuoteRegister To Reply
  6. 04-03-2020, 12:32 PM #6
    soodaakash04
    soodaakash04 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    India
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: Hourly calculation over a period of time

    Thanks for your reply, Waiting Patiently
    Reply With QuoteRegister To Reply
  7. 04-03-2020, 12:34 PM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,806

    Re: Hourly calculation over a period of time

    You might want to upload a sample file - it would help. Details at the top of the page.
    Reply With QuoteRegister To Reply
  8. 04-03-2020, 12:58 PM #8
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Hourly calculation over a period of time

    I cannot post the formula.

    See the attachment
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  9. 04-03-2020, 01:24 PM #9
    soodaakash04
    soodaakash04 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    India
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: Hourly calculation over a period of time

    Attaching a sample of the file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 04-03-2020, 01:27 PM #10
    soodaakash04
    soodaakash04 is offline
    Registered User
    Join Date
    04-03-2020
    Location
    India
    MS-Off Ver
    Excel 16
    Posts
    6

    Re: Hourly calculation over a period of time

    Hey Mehmet , thanks a lot for your help !!!

    But there is one more issue now , I have to arrange this data by Zone i.e. I need a count of how many stores are open between 8 and 9 AM, 9-10, 10-11 and so on in East then west then south and so on.
    Reply With QuoteRegister To Reply
  11. 04-03-2020, 03:42 PM #11
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Hourly calculation over a period of time

    Ok. Try this version.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date and time calculation excluding breaks, weekends for a time period
    By Pubhub in forum Excel General
    Replies: 2
    Last Post: 02-03-2017, 07:39 AM
  2. Half hourly data for three years - break down by time period
    By machds42 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2013, 08:16 PM
  3. Excel 2007 : Specific time period calculation from a time range
    By Khaldon in forum Excel General
    Replies: 11
    Last Post: 05-20-2011, 02:09 PM
  4. Specific time period calculation from a time range
    By Khaldon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:44 AM
  5. urgent solution needed to 'custom view' re-calculation problem!
    By phil in forum Excel General
    Replies: 1
    Last Post: 07-05-2006, 04:30 PM
  6. [SOLVED] urgent solution needed to 'custom view' re-calculation problem!
    By phil in forum Excel General
    Replies: 0
    Last Post: 07-05-2006, 01:21 PM
  7. urgent solution needed to 'custom view' re-calculation problem!
    By phil in forum Excel General
    Replies: 0
    Last Post: 07-05-2006, 01:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1