Dividing a currency value by a time value

C

Cecil

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.
 
K

Kieran

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with formula for finding last greater than/less than or equal to value 2
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Adding cells until they are greater than a lookup cell and returning a value 1
Finding the weighted average of text that have been given values 1
Average with criteria for adjacent cells ? 1
Calculate the median value before a specified list 0
Excel: counting times and dates during non-traditional hours 0
How To Rapidly Copy Formulas? 0

Top