Forum Discussion
Solved
Employee's working days by entry
Hi, I am trying to calculate how many days my employee's have worked each month from my transaction journal. Each day there are lines of entries which all have an operator code in a specific column,...
pottyponder oops, my bad I didn't account for them being date-time stamps and not just date. Here is the updated:
=IFERROR(ROWS(UNIQUE(FILTER(INT('Clacton Cash Draw record'!U:U),'Clacton Cash Draw record'!R:R=Figures!A2))),0)+ IFERROR(ROWS(UNIQUE(FILTER(INT('Dovercourt CashDrawerRecord'!T:T),'Dovercourt CashDrawerRecord'!P:P=Figures!A2))),0)+ IFERROR(ROWS(UNIQUE(FILTER(INT('Ipswich CashDrawerRecord'!T:T),'Ipswich CashDrawerRecord'!P:P=Figures!A2))),0)a couple nuances include:
a) if the same person worked at 2 DIFFERENT locations (i.e. listed on 2 different sheets) the same day)
b) if the person works after midnight (i.e. 12:30am the 'next' day) it will count as the next day (I didn't check to see if this is even an issue in your data.
That will depend on how you are doing the data import. If you are using a data query you will need to edit that query. Try going to Data->Get Data->Data Source Settings and then edit the data source you are using and edit your account or sign in using information.
Hi, this is the query that works if I remove the database password. I am not sure where to enter it.
Many Thanks Paul.