dividing one time by another

  • Thread starter Thread starter Adrian Bailey
  • Start date Start date
A

Adrian Bailey

If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where the
times are minutes:seconds) I get weird answers. If I reformat the cells with
[m]:ss, the formula doesn't work at all.

Any suggestions?

Adrian
 
Excel times are maintined as fractions of 24 hours. 1 second is
1/(24*60*60). 1 minute is 1(24*60). 1 hour is 1/24.

The display of time is formatted for human consumption. The display does not
affect the underlying values in the cells.
Use Ctrl+Accent grave(`), the key above the tab key to see what Excel
maintains as time. Repeat to return to normal display.

You might want to show us your times and your formats. We are not mind
readers.

Tyro
 
I get 1.756435 (formatted as General)

What do you get?

I entered the times as 01:16:12 and 00:43:23 to make sure I used the values you
shared.


Adrian said:
If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where the
times are minutes:seconds) I get weird answers. If I reformat the cells with
[m]:ss, the formula doesn't work at all.

Any suggestions?

Adrian
Click to expand...
 
conceptually - when You divide TIME/TIME You get dimensionless thing
ividing 10 hours to 2 hours - the result is 5
not 5 hours

other thing - if You enter 76:12 - this is in excel 76h12m not 76m12s

when You need to enter 76m12s You need to enter 0:76:12 (this is ok
converted to serial but changing format to [m]:ss gives You minutes and
seconds

But Could You explain - why You need to divide time to time and format this
as new time???

With bests
Henn

PS! I tried to to format Your divide to [m]:ss and I get 2529:16
Seems like works?
 
Dave Peterson said:
Adrian said:
If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where
the
times are minutes:seconds) I get weird answers. If I reformat the cells
with
[m]:ss, the formula doesn't work at all.

Any suggestions?
Click to expand...

I get 1.756435 (formatted as General)

What do you get?

I entered the times as 01:16:12 and 00:43:23 to make sure I used the
values you
shared.
Click to expand...

Thanks. I changed the format of the formula cells to General.

Now I can compare my race time with the winner's time. :)

Adrian
 
Now I can compare my race time with the winner's time. :)

If I had to guess, I would say most of the time it will be less.<g>

Rick
 
Back
Top