 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Formula with time
If I have 0:49 minutes in a cell, the number of hours John worked, and adjacent is $158, the amount John sold; how would I construct a formula to find out how much John would have sold on an hourly basis? Let's do it with the numbers you have: = 158 / 49 * 60 to give $193.47 per hour. Now, put 158 in A1, 0:49:0 in B1, and this formula in C1: =A1/B1/24 The reason for /24 rather than *60 is due to how Excel handles times - as fractions of a 24-hour day. Hope this helps. Pete > If I have 0:49 minutes in a cell, the number of hours John worked, > and adjacent is $158, the amount John sold; how would I construct a > formula to find out how much John would have sold on an hourly basis? =B1/(A1*24) where B1 is the amount, A1 the time.  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > If I have 0:49 minutes in a cell, the number of hours John worked, > and adjacent is $158, the amount John sold; how would I construct a > formula to find out how much John would have sold on an hourly basis? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.