LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i multiply an hourly rate by hours in Excel? Rackenford. Excel Discussion (Misc queries) 2 July 2nd 06 03:52 PM
multiply total hours by hourly pay charitydc Excel Discussion (Misc queries) 3 June 22nd 06 07:15 PM
Hourly rate times hours? L Excel Worksheet Functions 1 May 8th 06 06:27 PM
How can I calculate hours in a Hourly schedule in Excel? SUPERNAM Excel Worksheet Functions 6 January 17th 06 10:43 PM
how do I calculate hours spent x an hourly rate? JC Excel Worksheet Functions 2 January 5th 06 04:32 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"