+ Reply to Thread
Results 1 to 1 of 1

Specific time period calculation from a time range

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Exclamation Specific time period calculation from a time range

    From the attached sheet, I would like help please in a formula to extract time value for times that falls between 18:00 and 0600 next day only from cells A and B and have the result in Column D cells. as for the attached example, the requested formula should result in 4:05 in cell D1, and 5:42 in cell D2.
    Attached Files Attached Files
    Last edited by Khaldon; 05-18-2011 at 03:34 PM.

+ 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