Closed Thread
Results 1 to 15 of 15

Calculating Net Working Hours.

Hybrid View

  1. 03-13-2008, 06:07 PM #1
    amitmodi_mrt
    amitmodi_mrt is offline
    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.
    Reply With QuoteRegister To Reply
  2. 03-13-2008, 06:32 PM #2
    daddylonglegs
    daddylonglegs is offline
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,698
    I prefer to keep any communication within the forum. If you have any further queries on this subject then just post another reply to this thread....or you can PM me if I don't respond
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1