[hh]:mm:ss Custom Format

  • Thread starter Thread starter Ralph Bender, MBA
  • Start date Start date
R

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
 
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.
 
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!
 
Back
Top