Results 1 to 15 of 15

Calculating Net Working Hours.

Threaded View

  1. #8
    Forum Contributor
    Join Date
    03-13-2008
    MS-Off Ver
    Office 365
    Posts
    134
    What do you have in K$1 and K$2..?
    The formulla is working but not giving exact result.. i put the start time as 3/13/2008 10:00 in A2 and =now() in C2 (My current time is 3/14/2008 3:33 AM, I am in India) it is showing "Age of ticket = 4:46"
    however it should show "Age of ticket =7:00" as working hours ends at 17:00 PM.
    =============================================================

    I AM SORRY... IT WAS MY MISTAKE...
    IT WORKED.. I DIDNT NOTICED WHAT YOU WRITTEN FOR K2 AND K3...
    THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU VERY MUCH......

    Can i have your email id so that i can contact you if i need any help in future....?
    Last edited by amitmodi_mrt; 03-13-2008 at 06:12 PM.

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