+ Reply to Thread
Results 1 to 2 of 2

Converting Elapsed Time to Minutes

  1. #1
    Registered User
    Join Date
    10-11-2006
    Posts
    2

    Red face Converting Elapsed Time to Minutes

    I want to compute elapsed time (currently showing as H:M) to minutes. A1=StartTime, B1=EndTime, and C1=ElapsedTime. The formula in C1 is =HOUR(B1-A1)*60+MINUTE(B1-A1), and it works fine as long as I don't have a PM time in A and an AM time in B (or vice versa); otherwise I am getting an overflow error (Excel seems to have a problem with what it sees as a negative result). I have tried to remedy this by using the military time standard (24 hour basis) but I still get the error. Does anyone have a solution to this problem? Many thanks.
    Last edited by jcoffey; 10-12-2006 at 05:14 AM.

  2. #2
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259
    http://www.cpearson.com/excel/datearith.htm

    Look at the section entitled "Subtracting Times". It explains WHY this is happening and a solution.
    Martin Short

+ 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