Monday, December 25, 2017

yogi_Compute Total Pay For Staff Based On Number Of Jobs Done On A Given Date

Google Spreadsheet   Post  #2327

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-25-2017

Use dates and time in multiple cells and text in other cells to calculate a number.

Hi - I'm trying to use several pieces of data to obtain a number.  

To be more specific, if JIM (entered into a cell) works for me on DATE at TIME (entered into cells on the same row) and he only does one project, he's paid X (entered into another cell on the same row).  If he works for me on the same date and time but does a second project (project details are entered on an adjacent row down), he's paid Y, etc.  The additional rows on which Jim works should be filled with a dash (-) as the total number will only be entered on one cell.

1 row = 1 job which pays $750, 2-3 jobs at the same time and date pays $850, 4-5 jobs at the same time and date pays $900, and 6 pays $1,000.

Any ideas?