Results 1 to 4 of 4

Thread: Hours Calculation between two times

Threaded View

excel_learner Hours Calculation between two... 11-21-2012, 12:14 PM
ayazgreat Please find attached format... 11-21-2012, 01:21 PM
excel_learner Thanks, Ayaz 11-21-2012, 04:55 PM
ayazgreat You are most welcome 11-21-2012, 05:04 PM
Previous Post Previous Post   Next Post Next Post
  1. 11-21-2012, 12:14 PM #1
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    15

    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
« 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