Results 1 to 18 of 18

Using a data table to replace time values with points values.

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2022
    Location
    Leyland, England
    MS-Off Ver
    2019
    Posts
    6

    Using a data table to replace time values with points values.

    Hi
    I need a formula that will insert a points value into a cell when a time value has been input in another cell.
    Production workers log their time spent using up to 5 different machines in a working day and I have to calculate their exposure points.
    On the attached spreadsheet I have a data table for the values and a timesheet for a worker.
    The values that are showing in the ELV(400pts max) row are manually calculated from the data table, where multiple time values are input, the points are cumulative and this is where I need your help please.
    Can anyone please write me a formula that will do this?

    Your help and advice will be much appreciated.
    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] VBA Code replace old values to new values depends upon column values
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2015, 08:19 AM
  2. Look Up Values with 7000+ data points
    By dkang2007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-26-2015, 02:33 PM
  3. Choose Time Points Based on Values from Combo Box in User Form
    By Chaba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2014, 01:42 PM
  4. Replies: 1
    Last Post: 09-09-2014, 05:24 AM
  5. Replace values according to a table
    By lduke in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2011, 12:57 AM
  6. Assigning values to data points
    By charmandering in forum Excel General
    Replies: 4
    Last Post: 03-23-2010, 09:34 PM
  7. Way to find/replace multiple values at the same time?
    By godfire in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-24-2007, 01:42 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