+ Reply to Thread
Results 1 to 2 of 2

Conditional time calculation including Saturday in excel 2007

  1. #1
    Registered User
    Join Date
    07-05-2013
    Location
    Ltstan since
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Conditional time calculation including Saturday in excel 2007

    I am using Microsoft Excel- 2007 and need to calculate the total WORK-hours (09:00-17:30) between two date/time-stamps; Including Saturdays but excluding Sundays & Holidays
    If we see below example then total hrs should be 01:00:00 hr only as call received time is after shift hours i.e. 06:30 PM

    issue received time in Cell - A1=6/28/2013 6:30:00 PM
    issue acknowledge time in Cell - A2=6/29/2013 10:30:00 AM

    DayStart= 9:30:00 AM - Cell D1

    DayEnd= 5:30:00 PM - Cell D2

    HolidayList= "07/01/2013" – Cell D3

    Please share the formula to use for above scenario. Thanks for the help!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Conditional time calculation including Saturday in excel 2007

    Cross post http://www.excelkey.com/forum/viewtopic.php?f=2&t=3634

    Pse read forum rules and http://www.excelguru.ca/content.php?184

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1