+ Reply to Thread
Results 1 to 5 of 5

Time sheet(difference) issue. Help!!!

  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    florida,usa
    MS-Off Ver
    Excel 2007
    Posts
    3

    Thumbs up Time sheet(difference) issue. Help!!!

    TKS Adjustment.xlsx

    C2 = total number of hours in first session
    D2 = total number of hours in second session
    E2 = Sum of C2 and D2
    F2 = E2 minus 8 hours

    The first 2 columns are okay.

    I am having issues with F2 please can anybody help. I will prefer everything to show in military time.

  2. #2
    Registered User
    Join Date
    05-28-2012
    Location
    florida,usa
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Time sheet(difference) issue. Help!!!

    Any help for me?

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Time sheet(difference) issue. Help!!!

    Hello
    try

    =IF((8/24) >E2,TEXT((8/24)-E2,"hh:mm:ss")&" "& "Short",TEXT(E2-(8/24),"hh:mm:ss"))
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  4. #4
    Registered User
    Join Date
    05-28-2012
    Location
    florida,usa
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Time sheet(difference) issue. Help!!!

    Thanks vlady, it works!

  5. #5
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Time sheet(difference) issue. Help!!!

    If you are satisfied with the response then please mark the thread as solved.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

+ 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