Re: Re: Excel Help. Calculating Elapsed Time

[Mitz]

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