adding racing times

[nave]

I have a horse racing hobby and I'm trying to figure out how to add some
times. Since Horses are timed in fifths of a second i am having some
trouble. Example: 28 4/5 (currently I type 28.4) + 28 4/5 (28.4) = 57
3/5 but excel gets 56.8 because it adds in tenths. I know i can
manually type in 28.8 + 28.8 and then convert back fifths and get the
right answer but I like to copy the info verbatim from the racing
paper...any suggestions? Thank you, this is my first time here and new
to excel.

 

[J.E. McGimpsey]

If you type

28 4/5

you can do the addition and display it in 5ths:

A1: 28 4/5
A2: 28 4/5
A3: A1 + A2 ==> 57 3/5

Format A3 as Format/Cells/Number/Custom 0 0/5

 

[nave]

Can anyone else give me a serious answer

 

[Harlan Grove]

Can anyone else give me a serious answer?

J.E. gave a serious answer, but is seems you didn't like it. What you want
to do has been discussed before. Try a Google Groups search. Or enter times
as text by preformatting entry cells with Text number format, then total
them (e.g., a range named Times) using

=SUMPRODUCT(INT(Times))+SUMPRODUCT(MOD(Times,1))*2

If this still doesn't satisfy, figure out something better on your own.

 

[Chip Pearson]

You can use the DOLLARDE and DOLLARFR functions. For example, if
you have time in A1 and A2, use

=DOLLARFR(DOLLARDE(A1,5)+DOLLARDE(A2,5),5)

This will return a result of 57.3.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Chip Pearson]

I should have added that the DOLLARDE and DOLLARFR functions are
part of the Analysis ToolPak add-in, so you must have this loaded
(Tools menu, Add-Ins).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

You can use the DOLLARDE and DOLLARFR functions. For example, if
you have time in A1 and A2, use

=DOLLARFR(DOLLARDE(A1,5)+DOLLARDE(A2,5),5)

This will return a result of 57.3.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I have a horse racing hobby and I'm trying to figure out how

to
add some

times. Since Horses are timed in fifths of a second i am having some
trouble. Example: 28 4/5 (currently I type 28.4) + 28 4/5 (28.4) = 57
3/5 but excel gets 56.8 because it adds in tenths. I know i can
manually type in 28.8 + 28.8 and then convert back fifths and get the
right answer but I like to copy the info verbatim from the racing
paper...any suggestions? Thank you, this is my first time

here
and new

 

[nave]

Thank you Chip for that info.... very helpful

JE I am sorry but I tried what you said on my home computer and its not
excel just a spreadsheet and of course it did not work but you are
right so again I am sorry

Harlan...Also Thank you very much

This site is great!