| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pay per hour?
How can I figure this out? I have a cell for total time worked in this format: 3:01:00. Then I have the total pay cell in currency for example: $26.96. How do I find what the pay per hour works out to be? I tried just doing division but it comes out wrong. Thanks Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=517969 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pay per hour?
Jennifer
If your start time is in cell B6 and your end time is in cell C6 the formula in D6 to get a number rather than a time would be =(C6-B6)*24 formatted as general. If that's in D6 and your total pay is in E6 then your formula in, say, F6 would be =E6/D6 Regards Trevor "jlogan21" wrote in message ... How can I figure this out? I have a cell for total time worked in this format: 3:01:00. Then I have the total pay cell in currency for example: $26.96. How do I find what the pay per hour works out to be? I tried just doing division but it comes out wrong. Thanks Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=517969 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pay per hour?
Thank you for that and sorry it has taken me so long to reply. I did as you stated and these are the results. Just wanted to make sure I am doing this right. Time IN: 7:59 AM Time Out: 1:42 PM Total Time came out to be: 5.716667 Total Earned is: $57.60 and pay per hour is $10.08. Just was a bit confused about the total time bein 5.71? Is that right? Thanks again, Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=517969 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pay per hour?
Can someone tell me if the above is correct? As far as the time worked? Thanks Jennifer -- jlogan21 ------------------------------------------------------------------------ jlogan21's Profile: http://www.excelforum.com/member.php...o&userid=30111 View this thread: http://www.excelforum.com/showthread...hreadid=517969 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pay per hour?
Yes that is correct. 5.716667 hours is the same as 5 hours, 43 minutes (0.716667*60) -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=517969 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| Round Time with Conditions | Charts and Charting in Excel | |||
| How can I round an hour to the nearest 1/4 hour? | Excel Worksheet Functions | |||
| convert 100 minute hour to a 60 minute hour | Excel Worksheet Functions | |||
Linear Mode
