+ Reply to Thread
Results 1 to 3 of 3

need to calculate max excluding the weekends

  1. #1
    Forum Contributor
    Join Date
    08-03-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    120

    need to calculate max excluding the weekends

    I have a table with dates in column a and price in column b. I want to determine the maximum price every 24 hours with the condition that the weekend is excluded. How do I put this as formula?for example, friday 12 pm, it needs to do 12 hours until saturday 00:00 and then skip 48 hours until monday 00:00 and then do the next 12 hours on monday in order to get a full 24 hour cycle.

    any ideas?

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: need to calculate max excluding the weekends

    Hi,

    Does the date column include time stamps as well? Please post a sample template of your workbook using "Go Advanced" option.

  3. #3
    Forum Contributor
    Join Date
    08-03-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    120

    Re: need to calculate max excluding the weekends

    Book3.xlsx
    column a has date
    column b is time
    column c is the price column where i want to find the max every 24 hours excluding weekends.
    Attached Files Attached Files

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: need to calculate max excluding the weekends

    Hi freak11,

    This is an easy pivot table answer if you make your dates, real dates and group them by day. See the attached with what I think you want.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to calculate TAT excluding weekends
    By Rem0ram in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-05-2013, 08:48 AM
  2. How do you calculate the hours between two dates excluding the weekends?
    By Charoum in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-03-2013, 08:10 PM
  3. calculate the time between two dates excluding weekends
    By Dumy in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-04-2011, 05:07 AM
  4. Calculate difference between dates excluding weekends
    By nitinjoshi123 in forum Excel General
    Replies: 15
    Last Post: 05-27-2008, 06:32 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1