Time entries

  • Thread starter Thread starter PAULR
  • Start date Start date
P

PAULR

I'm unable to figure out how to enter time in an Excel 97
worksheet, other than as it relates to a date.
Specifically, now that I've retired and want to play the
ponies (!), I want to design a spreadsheet that will
extrapolate to longer and shorter distances based on my
original entries.

For example, how can I enter the following times in
minutes, seconds, and tenths of seconds for various points
in a race and assign these times with a value of 100
without the times referencing a time of day or date?

100 = 1:08.60 1:02.40 56.20

Secondly, assuming these entry can be made, what is the
formula by which, just changing one of the parameters,
either a time or the arbitrary value of 100, I can produce
proportionally equal values at either faster or slower speeds?

I'm not the most technically literate person but I have
worked with Excel in business functions for several years
and would hope I can understand the explanation. Don't be
afraid to talk down to me!

Thanks for any assistance you can provide.
 
I'm unable to figure out how to enter time in an Excel 97
worksheet, other than as it relates to a date.
Specifically, now that I've retired and want to play the
ponies (!), I want to design a spreadsheet that will
extrapolate to longer and shorter distances based on my
original entries.

For example, how can I enter the following times in
minutes, seconds, and tenths of seconds for various points
in a race
Click to expand...

First of all, ignore what you see in the formula bar. Excel will frequently
display a date/time there.

You can enter the times exactly as you've written them:

If you enter in the form mm:ss.00, Excel will interpret that entry as
minutes:seconds and tenths or hundredths of seconds.

To have it display in the same manner, custom format the cell as mm:ss.00 or,
if the number minutes can go over 60, [mm]:ss.00

and assign these times with a value of 100
without the times referencing a time of day or date?

100 = 1:08.60 1:02.40 56.20
Click to expand...

I don't understand your algorithm to obtain 100. If no one else does, perhaps
you could post it here.
Secondly, assuming these entry can be made, what is the
formula by which, just changing one of the parameters,
either a time or the arbitrary value of 100, I can produce
proportionally equal values at either faster or slower speeds?
Click to expand...

Again it depends on your setting out the algorithm to get the 100.
I'm not the most technically literate person but I have
worked with Excel in business functions for several years
and would hope I can understand the explanation. Don't be
afraid to talk down to me!

Thanks for any assistance you can provide.
Click to expand...

--ron
 
Back
Top