+ Reply to Thread
Results 1 to 2 of 2

Calculate between two date/time fields?

  1. #1
    Registered User
    Join Date
    08-27-2008
    Location
    Oregon
    Posts
    3

    Cool Calculate between two date/time fields?

    Hello,

    How do I calculate the time in hours or days between two fields (startDate and FinishDate in Date/Time format 8/12/2008 14:41) less weekend and holiday?

    Example:
    StartDate FinishDate Result
    8/12/2008 12:09 8/12/2008 14:41 92 mins or 1.53 hrs or 0.936 days

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    =A1-A2 formatted as Time
    HTH
    Ola

+ 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. Projected DATE/TIME between specific hours
    By additude in forum Excel General
    Replies: 2
    Last Post: 08-03-2008, 06:32 AM
  2. How to parse date/time stamp into different fields?
    By chrishornbeck in forum Excel General
    Replies: 1
    Last Post: 05-07-2008, 12:39 PM
  3. merging text and data fields with zeroes
    By bcaplan1940 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2007, 04:03 AM
  4. File fails to calculate - corrupted?
    By bahguy in forum Excel General
    Replies: 3
    Last Post: 08-09-2007, 03:53 AM

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