+ Reply to Thread
Results 1 to 6 of 6

Adding Colums with time and * by hourly rate

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    Adding Colums with time and * by hourly rate

    I have several numbers entered as h:mm and I like to add them and multiply by an hourly rate. for example

    A1 6:52 min
    A2 5:42 min
    A3 6:00 min

    I have the column set as time h:mm so when I add all the times it comes out correct but I want to calculate $6.5 per hour times all the hours in column A1:A3 the number does not out correctly I have the following

    =sum(A1:A3)*6.50

    or

    I convert the hours and minuets to minutes total and multiply b .183 which is 6.50 divided by 60

    Any help will be appreciated.

    thanks

  2. #2
    Registered User
    Join Date
    02-11-2013
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    11

    Re: Adding Colums with time and * by hourly rate

    Try this =(HOUR(SUM(A1:A3))+MINUTE(SUM(A1:A3))/60)*6.5 let me know if this answer your question.
    Javier Roques

  3. #3
    Registered User
    Join Date
    02-25-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    Thumbs up Re: Adding Colums with time and * by hourly rate

    Thank you so much that worked perfectly, I would have never figured it out. Thanks again

  4. #4
    Registered User
    Join Date
    02-25-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding Colums with time and * by hourly rate

    Another question now that the above formula works, I want to add the above figure with a new figure so I use =sum(e1:e2) e1 being a dollar amount and e2 being the result of the formula above but it shows 0:00 any ideas on that one please.

  5. #5
    Registered User
    Join Date
    02-25-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding Colums with time and * by hourly rate

    Another problem reference to the formula above =(HOUR(SUM(A1:A3))+MINUTE(SUM(A1:A3))/60)*6.5 A1:A3 is 49:30:00 (h:mm:seconds) does not come out correctly the formula shows $9.50 where it should be $321.00

    thanks

  6. #6
    Registered User
    Join Date
    02-25-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding Colums with time and * by hourly rate

    I found my answer via a different post =(column)*24*Rate for me it was =F39*24*6.50

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1