Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time measurements fromulas?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time measurements fromulas?
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) "Todd W." <Todd wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time measurements fromulas?
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. -- Regards, Fred "Todd W." <Todd wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering Times | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
time differences in a column | Excel Worksheet Functions | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |