+ Reply to Thread
Results 1 to 1 of 1

How to calculate the closure Date and Time

  1. 03-15-2014, 03:45 PM #1
    Abraham Moses
    Abraham Moses is offline
    Registered User
    Join Date
    02-15-2014
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Talking How to calculate the closure Date and Time

    Hi Everyone,

    I need help to calculate the Closure Date and Closure time, refer to the excel file attached.

    Once the call is logged in I need to calculate the closure date (column H) and time (column I) based on SLA agreed which is in column E, and based on Site Accessible Hours which is in column F, and based on site accessible days which is in column G.


    Regards,
    Abraham
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [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. How to get the expected time of closure
    By Abraham Moses in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-15-2014, 05:37 PM
  3. Formula to Calculate Total time spent between Start Date & Time and End Date & Time
    By Manish_Gupta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 06:49 AM
  4. [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
  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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1