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
|