Results 1 to 7 of 7

Calculate time different between two date:time

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    12

    Calculate time different between two date:time

    I need help for calculating duration between two dates:time excluding weekends. here with attached the file.
    Thank you.

    Open Time= 2015.06.16 15:46:44 Close Time= 2015.06.18 00:47:05 Duration= ?????
    Open Time= 2015.06.12 04:01:12 Close Time=2015.06.16 08:18:39 Duration= ????? (should be deduct the weekends)

    weekdays=monday 00:00:00 to friday 23:59:59
    weekends=saturday 00:00:00 to sunday 23:59:59
    Attached Files Attached Files
    Last edited by thisara; 06-19-2015 at 12:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate time remaining based on end date & time and current date
    By Kaz09 in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 08-19-2014, 07:11 AM
  2. Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  3. [SOLVED] Calculate number of hours from Start date and time and End date and time
    By sathyasun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2013, 01:04 AM
  4. [SOLVED] Calculate Time from different Date and Time columns
    By Siddps in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-01-2013, 09:23 AM
  5. [SOLVED] Calculate turnaround time for 9pm-6am working time & Start/End date may be on weekend
    By Wauiwa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2012, 02:36 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