Calculating time
 

Ive got a time which has been formated to [m]:sec (ie: 592:15 or 592 minutes
and 15 seconds) which I am trying to divide into a general number (ie: 52) or
52/592:1, the answer I am getting is 182083:03

Example...a kid score 52 points in 592:11 time played, how many points did
he score per minute played? As I see it I should be getting .0878 points per
minute.

What am I doing wrong?

Tks

What you get is the points per day. Divide by 24/60 and you get what you
expected.
So something like =52/A1/24/60 and then Format as General. Important,
because Excel will probably format as time, which may confuse you even more!

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"BIYB" wrote in message
...
Ive got a time which has been formated to [m]:sec (ie: 592:15 or 592
minutes
and 15 seconds) which I am trying to divide into a general number (ie: 52)
or
52/592:1, the answer I am getting is 182083:03

Example...a kid score 52 points in 592:11 time played, how many points did
he score per minute played? As I see it I should be getting .0878 points
per
minute.

What am I doing wrong?

Tks

A1: 52
B1: 592:11:00
C1: =A1/(B1*24) formatted as General = 0.0878106442261687

Regards

Trevor


"BIYB" wrote in message
...
Ive got a time which has been formated to [m]:sec (ie: 592:15 or 592
minutes
and 15 seconds) which I am trying to divide into a general number (ie: 52)
or
52/592:1, the answer I am getting is 182083:03

Example...a kid score 52 points in 592:11 time played, how many points did
he score per minute played? As I see it I should be getting .0878 points
per
minute.

What am I doing wrong?

Tks

Try this formula and ensure the cell is formatted as a number (not a
time/date):

=52/(A1*1440)

where A1 contains 592:15.

Regards,


--
Barrie Davidson


------------------------------------------------------------------------
Barrie Davidson's Profile: http://www.excelforum.com/member.php...o&userid=16930
View this thread: http://www.excelforum.com/showthread...hreadid=387323