+ Reply to Thread
Results 1 to 3 of 3

How to calculate cost charged for numbers of hours spent?

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    How to calculate cost charged for numbers of hours spent?

    Hi guys,

    I have 154:00 hours spent on a project.

    I am charged 19.50 per hour. What formula do I need to input to calculate how much I am charged on a monthly basis??

    Thanks so much
    Thanks,

    R.



  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: How to calculate cost charged for numbers of hours spent?

    Simply multiply the hourly rate 19.50 by 154.
    Then divide by the hours in the working day (which you havent specified) to give a daily rate.
    Then multiply by the average number of days in the month (30 ?) to give a monthly rate.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: How to calculate cost charged for numbers of hours spent?

    Hi Special K

    this should be ok for me to go away and play with.

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate reduction in fee charged based on lower rate
    By Aland2929 in forum Excel General
    Replies: 1
    Last Post: 03-09-2017, 08:32 AM
  2. Needs to distribute spent hours to pick, normal and low hours.
    By bebo021999 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2015, 10:36 PM
  3. [SOLVED] Rate changes after 40 hours and need to calculate total cost?
    By y_not in forum Excel General
    Replies: 12
    Last Post: 10-06-2015, 12:16 PM
  4. [SOLVED] How to calculate hours worked to trigger a cost
    By rjassal82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-03-2013, 04:45 PM
  5. calculate the hours spent for each status
    By Rose Mendoza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2012, 09:35 PM
  6. [SOLVED] how do I calculate hours spent x an hourly rate?
    By JC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2006, 12:35 PM
  7. Formula Question:pulls all hours charged
    By Nic in forum Excel General
    Replies: 1
    Last Post: 10-04-2005, 09:05 PM

Tags for this Thread

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