With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, December 25, 2017
yogi_Compute Total Pay For Staff Based On Number Of Jobs Done On A Given Date
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.