View Single Post
  #3   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

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