Results 1 to 4 of 4

Multiply money/hours, SUM right data that has to be ''filtered'' (example in atachment)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Arnhem, The Netherlands
    MS-Off Ver
    2007
    Posts
    102

    Multiply money/hours, SUM right data that has to be ''filtered'' (example in atachment)

    Hey people,

    In my sheet you can see there are 3 kind of ''fieldwork'' i added in my example sheet.
    I would like for my time to be multiplied with the hours it says in each row, which then gets filtered so i can have a total of each 3 kinds of work.

    So if 4jun traveltime started 6:00 - 10:00 it calculates that is 4 hours, then the 4 hours have to be multiplied with rate from traveltime somehow, so you get 4*55 in this case.

    If then on 9jun there is traveltime again this time 2 hours, again the multiply in the same spot (Kolum J), and then later on added all the travel times together in the total travel time slot (yellow), same goes for workinghours and waiting time.

    If possible i would also see the total time (for traveltime i made it blue).

    I hope i explained my intentions sufficient.

    Any tips and/or suggestions would be greatly appreciated.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] what data type do i use when i multiply time by money? excel 2007
    By elliottt in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 02-21-2014, 06:00 AM
  2. multiply hours by dollars if hours are within certain range
    By children in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2013, 05:28 PM
  3. Calculate money/hours between spesific time
    By J0HNiE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2010, 10:52 PM
  4. hours multiplied by money
    By Tom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2006, 03:40 PM
  5. [SOLVED] Hours multiplied by money
    By Eileen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-22-2006, 08:45 AM
  6. [SOLVED] how to multiply time by money
    By chriscadstud in forum Excel General
    Replies: 2
    Last Post: 10-30-2005, 12:05 AM
  7. [SOLVED] Hours and Money
    By shaun in forum Excel General
    Replies: 3
    Last Post: 01-28-2005, 02:06 PM

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