Time measurements fromulas?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to measure the difference in times for swimming. I am having a
difficult time in getting a formula to read column A & B and measuring the
difference in mm:ss.00. Can anyone help?
 
Simply take one form the other to get the difference, it is just numbers.
Format the result cell as mm:ss.00

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
What's in column A and B? If the data is in time format (eg, mm:ss), you just
subtract one from the other (=b1-a1). If your data is in some other format, let
us know and we'll show you how to convert it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Variable measurement analysis 2
Displaying negative [h]:mm:ss 2
Time of Day vs Measured Time 6
pasting time from html 12
Combining 2 kinds of graphs [how?] 2
Filter date time data 1
SUMPRODUCT issue 4

Back
Top