Home › Forums › Computer Problems › Software › Excel Help. Subtract the Second Time From the First Time. Value Error! › Re: Re: Excel Help. Subtract the Second Time From the First Time. Value Error!
I was able to do the calculation by the following method:1) I selected the cells that hold the time (in my sample B2 â€“ faster runner and B3 â€“ slower runner).2) I opened the format cells dialog box. In 2007, Home tab/Number group/click drop-down arrow next to the default format/click More Number Formats in the list that appears. In 2003, click the Format menu, click Cells, click the number tab.3) In the list of categories on the left, I chose Custom. Then in the list at the right I found one to match the type of values in this scenario: mm:ss.0 (Be sure that the punctuation between seconds and tenths of seconds is a period â€“ not a colon.) If you donâ€™t see that choice in