Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is toal time in two colums. If added togeather you get
30:39 20:47 = 51:26. Total pay is 705 if divided on calulator you get $ 13.76 per hour. However trying to calulate hours / dollars is killing me. PLEASE HELP WITH FORMULA. The issue is if the field goes over 24 hours my 30:39 becomes 6:39. 30.00 39 1839.00 Tot Drive Min 20.00 47 1247.00 Tot Client Min 3086.00 Total Work Min $13.71 Hourly Rate 51.43 Total Work H:M PLEASE HELP THIS IS MAKING ME CRAZY AND THE ONLY WAY i CAN GET TO WORK IS TO MANUALLY PUT 30 AND 20 IN TO GET HOURLY RATE. If you want to see excel please email me and I can send this I just cant figure it out. I am trying to help my wifes business and want to be the hero :-) *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i multiply an hourly rate by hours in Excel? | Excel Discussion (Misc queries) | |||
multiply total hours by hourly pay | Excel Discussion (Misc queries) | |||
Hourly rate times hours? | Excel Worksheet Functions | |||
How can I calculate hours in a Hourly schedule in Excel? | Excel Worksheet Functions | |||
how do I calculate hours spent x an hourly rate? | Excel Worksheet Functions |