View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
don shields don shields is offline
external usenet poster
 
Posts: 1
Default Help!!!. I am trying to calculate hourly pay mixing hours and dollars

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 ***