Forum Discussion
mik618
Helper I
Helper IMeasure to calculate time worked
Hi There, I'm looking to try and calculate a measure to show how mant hours & Minutes a staff member worked per day. Staff work on appointments that have a start date and time, and an end d...
camargos88
Community Champion
Community ChampionHi mik618 ,
I've created this file: Download PBIX
It creates the ranges for your appointments, so you can calculate without overlaps.
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
mik618Helper I
Helper IThanks camargos88 for this,
The only problem (my fault for simplifying the example I gave!) is that appointments can be a matter of minutes, rather than hours, so really i need to count minutes worked, and later convert to total hours and minutes,
Thanks for your help
- camargos88
- mik618
Thanks camargos88
for example a snip of the staff table might look like this;
Staff Appointment Start End Staff1 Appointment1 1.15pm 2.10pm Staff1 Appointment2 3pm 5.15pm Staff1 Appointment3 4pm 5.30pm Staff1 Appointment4 7pm 8pm Staff2 Appointment1 9.15am 4pm Staff2 Appointment2 9am 2pm - camargos88