Dividing a currency value by a time value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook to track my online poker progress. I want to calculate my average hourly income at the different game types. I have total time spent at the game type and total winnings. All I want to do is divide the total winnings by total time and get winnings per hour.

Need a little help

thanks.
 
Time is stored in excel as a 'percentage' of an whole number.
Excel stores this internally this way, it just displays 0.1 as 2:24
Dates are stored as whole numbers starting from 1-1-1900.

To show the earnings per hour then the formula will be

earnings / time * 24 - where the time is entered in hour
in excel
 
Back
Top