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.
I have practically no experience, but if convert .mdb to .accdb is it the same issue? My guess connector doesn't work properly with .mdb files.
Yes I have the same problem with accdb as the mdb, there wasn't an issue when I was using Excel 2016.
- maybe start a new thread specifically about this issue because I also have little experience in querying data from database files.