[hh]:mm:ss Custom Format

[Ralph Bender, MBA]

How do you do basic arithmetic on these formats?

I want to divide 3 hours 35 minutes by 26.2. I should get something that
looks like 8 minutes and 12 seconds.

I've tried using the subject custom format, but get something totally
different:
A1 = 03:35:00
A2 = 26.2 (general format)
A3 = =a1/a2 and displays as: 4211:29:52 (using subject format).

I'd really appreciate some guidance on the use of these formats, as I'd like
to do some modeling of marathon race paces.

Thanks,
ralph

 

[JE McGimpsey]

Your format is fine, but there's something else going on, because when I
enter

A1: 03:35:00
A2: 26.2
A3: =A1/A2

I get 00:08:12.

So either A1 is not 3:35:00 (check by formatting as General), or your
formula isn't what you listed.

 

[Ralph Bender, MBA]

When I change format to general, I get 0.149305555555556.
So I reentered everything in the next column and get what you got.
Any idea what else was happening?
In any case, thanks!