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. 12-27-2012, 04:11 PM #1
    LalitPandey87
    LalitPandey87 is offline
    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))
    Reply With Quote Reply With Quote
  2. 12-27-2012, 06:18 PM #2
    mag
    mag is offline
    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
    Reply With Quote Reply With Quote
  3. 12-27-2012, 06:47 PM #3
    LalitPandey87
    LalitPandey87 is offline
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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. Resize a Rectangle shape according to the total number of row using VBA
    By LalitPandey87 in forum Excel Help
    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

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