I need to measure time in fifths of a second, example 1:30.4 read one minute,
thirty seconds and four tenths of a second. Can it be adjusted somehow to
read 1:30.2, read one minute, thirty seconds and 2 fifths?

Thanks in advance as always!!

M.A.Tyler

Hi,

To the best of my knowledge, if you want to keep it as a time as far as
Excel is concerned, you can not do this.

--
Cheers,
Shane Devenshire


"M.A.Tyler" wrote:

I need to measure time in fifths of a second, example 1:30.4 read one minute,
thirty seconds and four tenths of a second. Can it be adjusted somehow to
read 1:30.2, read one minute, thirty seconds and 2 fifths?

Thanks in advance as always!!

M.A.Tyler

If you are satisfied showing your time in
seconds and fifth of seconds, i.e. 90 2/5
them multiply your time by 24*60*60
and custom format it with 0 ?/5

I don't really care if Excel treats it as a time or not, it's just a number
to me. My problem is that our numeric system is based on ten numbers. So how
can I get Excel to think in terms of fifths, as opposed to tenths? Like
..10X10 would equal 1.0 & .20X5 would also equal 1.0. How can I manipulate
Excel to think in terms of the later?

"ShaneDevenshire" wrote:

Hi,

To the best of my knowledge, if you want to keep it as a time as far as
Excel is concerned, you can not do this.

--
Cheers,
Shane Devenshire


"M.A.Tyler" wrote:

I need to measure time in fifths of a second, example 1:30.4 read one minute,
thirty seconds and four tenths of a second. Can it be adjusted somehow to
read 1:30.2, read one minute, thirty seconds and 2 fifths?

Thanks in advance as always!!

M.A.Tyler

A1 = 1:30.4 (m:s.0)

=TIME(,,INT(A1*86400))+ROUND((A1-TIME(,,INT(A1*86400)))/2,7)

Format as m:s.0 or mm:ss.0

Note that you won't get an exact correlation due to rounding:

10th...........5th
0.0............0.0
0.1............0.1
0.2............0.1
0.3............0.1
0.4............0.2
0.5............0.3
0.6............0.3
0.7............0.4
0.8............0.4
0.9............0.4

See this screencap for a comparison with Herbert's method:

http://img299.imageshack.us/img299/7795/10sto5skl6.jpg

--
Biff
Microsoft Excel MVP


"M.A.Tyler" <Great Lakes State wrote in message
...
I need to measure time in fifths of a second, example 1:30.4 read one
minute,
thirty seconds and four tenths of a second. Can it be adjusted somehow to
read 1:30.2, read one minute, thirty seconds and 2 fifths?

Thanks in advance as always!!

M.A.Tyler

The rounding won't be a problem, however after further review cell A1 reads
130.40 and is formated "general". So I guess it's not really time at all, but
a number. I would still like to convert the .40 tenths to .20 fifths. Or
since your method worked fine, some way to convert the 130.40 to 1:30.4 would
work.

Thank you for your help! Sorry for the confusion.

M.A.Tyler

"T. Valko" wrote:

A1 = 1:30.4 (m:s.0)

=TIME(,,INT(A1*86400))+ROUND((A1-TIME(,,INT(A1*86400)))/2,7)

Format as m:s.0 or mm:ss.0

Note that you won't get an exact correlation due to rounding:

10th...........5th
0.0............0.0
0.1............0.1
0.2............0.1
0.3............0.1
0.4............0.2
0.5............0.3
0.6............0.3
0.7............0.4
0.8............0.4
0.9............0.4

See this screencap for a comparison with Herbert's method:

http://img299.imageshack.us/img299/7795/10sto5skl6.jpg

--
Biff
Microsoft Excel MVP


"M.A.Tyler" <Great Lakes State wrote in message
...
I need to measure time in fifths of a second, example 1:30.4 read one
minute,
thirty seconds and four tenths of a second. Can it be adjusted somehow to
read 1:30.2, read one minute, thirty seconds and 2 fifths?

Thanks in advance as always!!

M.A.Tyler