Results 1 to 4 of 4

Thread: Hours Calculation between two times

  1. 11-21-2012, 12:14 PM #1
    excel_learner
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    14

    Hours Calculation between two times

    I get an error in calculation of hours for OT calculation when I have 9:00 PM to 12:00 AM in formula. I have attached the example sheet.

    Kindly assist.
    Attached Files Attached Files
    Last edited by excel_learner; 11-21-2012 at 05:58 PM.
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!
    Reply With Quote Reply With Quote
  2. 11-21-2012, 01:21 PM #2
    ayazgreat
    ayazgreat is offline
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    Please find attached format managed by myself if this helps you, you can change and adjust the same as per your requirment.

    Ayaz
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  3. 11-21-2012, 04:55 PM #3
    excel_learner
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    14
    Thanks, Ayaz
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!
    Reply With Quote Reply With Quote
  4. 11-21-2012, 05:04 PM #4
    ayazgreat
    ayazgreat is offline
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    13
    You are most welcome
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Correcting “Negative” Time Difference Calculation in Excel
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  2. Formula Following Order Of Calculation BODMAS
    By paul_pearson in forum Excel Help
    Replies: 7
    Last Post: 03-27-2013, 02:07 PM
  3. Calculate the Hours
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 02-27-2013, 02:51 PM
  4. Calculation with different condition in a cell
    By LalitPandey87 in forum Excel Help
    Replies: 5
    Last Post: 04-04-2012, 08:38 AM
  5. Convert 24 hours to 48 hours in excel
    By dhiraj.ch185 in forum Excel Help
    Replies: 2
    Last Post: 11-15-2011, 09:02 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