Forum Discussion
Help with calculating time ???
Hi Jimmy,
Thank you for your reply.
What I'm looking for is two things,
Total hours worked per date
Then Total hours per days worked .
Ex: day one- 6 hrs, day 2- 8hrs, day 3- 10hrs, and day 4- 8hrs
Total 32 hours
Hello rf27
how the start and how the end time is defined? A was not able to identify it. What I did already mention is that in one day i saw 3 times. So how to identify what is the start and what is the end date?
What would also be important to now, is what exactly is you expected output. I can think of transforming date (poviting start and end) and with this a easy measure in DAX could be created.
Jimmy
Hey Jimmy,
The first transaction , and the last transaction of the day counts for the time duration... I cut out the important piece.. I have an 1 and 0 the represents my first in and last transaction. 1 = IN 0= OUT I'm looking to tabulate the IN & OUT of every day... I hope this brings clarity to my questions..
Hello rf27
are they connected in any way? meaning.. how to belong the first 1 with the first 0?
Possible logics to create your solution could be like this:
- split always every second row
- use the date (if the table exactly contains 2 rows per otherwise - otherwise logic would fail)
Another remark.. so you are doing already a trasforming of your data, keeping only first and last time of a day?
Could you please post a real table, that I can use it to build your solution
Jimmy
Hey Jimmy,
Yes, I have two unique identifiers.
empid, cardnum this connects me to the 1&0 transactions per person.. I also have a filter to get the 1&0 based on the reader desc.
Let me clean up the data set it's rather large
Richard