Home › Forums › Computer Problems › Software › Excel Help. Subtract the Second Time From the First Time. Value Error! › Re: Re: Excel Help. Calculating Elapsed Time
November 14, 2013 at 4:56 am
#34307
Note this example:Cell A1=26:56:97Cell A2=25:56:97The answer should be a difference of 1 minute. I need the answer to look like this: 1:00:00. The third segment of your time should be expressed as a decimal like this:Cell A1 = 26:56.97 (which would indicate 26 minutes, 56 seconds and 97 one-hundredths of a second.Cell A2 = 25:56.97When I entered these values with the decimal points between the last two numbers the formula works.I got this info here at an article about calculating elapsed time. http://ittrainingtips.iu.edu/excel/calculating-elapsed-time-in-excel/04/2009