Results 1 to 12 of 12

Need FORMULA for Date subtract Date equal bussiness hour (don't count weekend)

Threaded View

  1. 05-22-2015, 01:11 AM #1
    tuongtu3
    tuongtu3 is offline
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    818

    Need FORMULA for Date subtract Date equal bussiness hour (don't count weekend)

    Hello All,
    Is there a formula to subtract from date to date = hour but don't count weekend.

    5/21/15 4:53 PM - 5/25/15 4:53 PM = 48:00:00


    Regards,
    tt3
    Last edited by tuongtu3; 05-24-2015 at 03:29 AM. Reason: Solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. NETWORKDAYS with start date, end date, total days - if weekend subtract 1 from total
    By PConn31 in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 10-08-2014, 10:31 AM
  2. Excel date without weekend count
    By Teuntja123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2014, 08:51 AM
  3. [SOLVED] Userform Textbox Date - Subtract Weekend
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2012, 05:14 PM
  4. Count by date and hour
    By ChristiaanV in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2006, 07:30 PM
  5. [SOLVED] Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-19-2005, 08:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1