dividing one time by another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adrian Bailey - 09 Mar 2008 04:08 GMT

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

Reply to this Message

Tyro - 09 Mar 2008 05:30 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Adrian

Reply to this Message

Dave Peterson - 09 Mar 2008 11:58 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Adrian

Signature

Dave Peterson

Reply to this Message

Adrian Bailey - 10 Mar 2008 04:17 GMT

>> If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where
>> the
[quoted text clipped - 11 lines]
> values you
> shared.

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

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

Adrian

Reply to this Message

Rick Rothstein (MVP - VB) - 10 Mar 2008 04:28 GMT

> 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

Reply to this Message

Henn Sarv - 09 Mar 2008 23:02 GMT

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?

> 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
[quoted text clipped - 3 lines]
>
> Adrian

Reply to this Message

Rate this thread: