+ Reply to Thread
Results 1 to 1 of 1

working out Labour carges by time worked

  1. #1
    Forum Contributor
    Join Date
    08-26-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2007
    Posts
    149

    working out Labour carges by time worked

    Hi all,

    I have attached an example of something I can't get my head around!!

    Basically I have worked out how much time has been spent on a job, and then split that down to how many 15 mins it is. I then need to calculate that the first 4 15mins (1 hour) is charged at 10.00, then any number of 15 min blocks after that are charged at 2.50 each.

    1) on the blocks of 15 mins, where a time has gone into the 2nd 15 min, i need to round up the formula so it reads 2.
    2) How to work out the first 4 blocks being charged at 10.00 then the extra blcoks being charged at 2.50.

    I hope this makes sense.

    Donna
    Attached Files Attached Files

+ 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