LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BIYB
 
Posts: n/a
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating a rate for elapsed time? Keith Excel Discussion (Misc queries) 8 May 18th 05 09:14 PM
I need help with a formula calculating time Mark Excel Discussion (Misc queries) 2 April 27th 05 10:31 AM
Calculating negative time & creating scrol bars for fixed size txt box. Jonathan hill via OfficeKB.com Excel Discussion (Misc queries) 4 February 12th 05 02:08 AM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 09:15 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 03:50 PM


All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"