+ Reply to Thread
Results 1 to 1 of 1

Excel formulas calculate working hours bet two dates with criteria

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010
    Posts
    497

    Excel formulas calculate working hours bet two dates with criteria

    I want calculate hours bet two dates with conditions i want result as two dimensions.
    I have enclosed excel sheet please find the attachment

    activity start date activity end date
    4/5/2013 9:01 4/5/2013 23:00
    4/6/2013 10:01 4/7/2013 23:10

    if activity start time less than <10:00 am
    if activity start time greater than >10:00 am

    activity end date time should be completed same day 11:00 pm (23:00:00)
    activity end date time should be completed next day before 11:00 pm(23:00:00)

    if
    one result wants calculation
    if first criteria is met i want result calculate time between activity start and end time)
    if secone criteria is met i want result calculate time from start time till next day 23:00:00 pm

    another result want in true or fales
    if first criteria is met i want result "yes activity completed same day"
    if secone criteria is met i want result "yes activity completed second day"
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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