Results 1 to 9 of 9

Thread: How Can i Get total Over Time in Attendance Sheet

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    15
    Check this one

    =IF((N4-C4)>=TIME(8,0,0), (N4-C4)-TIME(8,0,0), TIME(8,0,0)-(N4-C4))

  2. #2
    Junior Member
    Join Date
    Dec 2012
    Posts
    16
    Rep Power
    0
    Still Not Works Should Be Like this Please Have Look on this file and Try Give a solution acordingly

    Test Attendance.xlsx

  3. #3
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    15
    Quote Originally Posted by mag View Post
    Still Not Works Should Be Like this Please Have Look on this file and Try Give a solution acordingly
    Please explain it more with steps.

Similar Threads

  1. Calculate Time Difference Between Time In HH:MM
    By Stalker in forum Excel Help
    Replies: 8
    Last Post: 03-28-2013, 03:27 PM
  2. Need Help Empolyee Attendance tracker
    By sanjeevi888 in forum Excel Help
    Replies: 2
    Last Post: 06-17-2012, 09:48 PM
  3. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM
  4. Replies: 2
    Last Post: 10-20-2011, 10:15 AM
  5. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •