+ Reply to Thread
Results 1 to 1 of 1

calculate hours between two dates

  1. #1
    Registered User
    Join Date
    02-08-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    1

    calculate hours between two dates

    Hi ,
    I am looking for your help for a formula which can calculate hours between two dates, as I have in sample file in cell A2 is the date n time when we have recd the order and cell B2 contains the date n time when we have closed the order what I am looking to calculate is; in how many working hours we have completed the order as per our shift timings which is Monday to Friday 5.00 PM to 2.30 AM
    Attached Images Attached Images
    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