Total Time per day for use with Deneb

[mscopuser]

I have this table (see below). From that table I want to have calculation of total time per day.

Secondly would it help full I could get a calculated coloum with the total time per day and projects.
I suppose that could be alterd to to do for sub project.  

(Please keep in mind that the time and date should be a date and time respectifly. As I will use this deneb)

I have tried chat gpt but no luck and of course google. 

Could you please help?

For context I am trying to use it with this concept:
2023 Week 06 | Power BI: Create a Calendar Heatmap – Workout Wednesday

 

Team member	Client	Projects	Sub-projects	Notes	Start date	Start time	End date	End time	Duration	Billed
Hans Anders	Learn Japanese	Listening	JapanesePod101		17.07.2024	08:14	17.07.2024	08:43	0:28:47	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		16.07.2024	07:48	16.07.2024	08:59	1:10:58	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		15.07.2024	19:27	15.07.2024	19:40	0:12:58	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		11.07.2024	21:31	11.07.2024	21:49	0:17:23	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		07.07.2024	21:56	07.07.2024	22:29	0:32:31	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		07.07.2024	13:12	07.07.2024	13:36	0:24:12	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		06.07.2024	19:42	06.07.2024	20:13	0:30:31	No
Hans Anders	Learn Japanese	Listening	JapanesePod101		02.07.2024	07:33	02.07.2024	08:24	0:51:21	No

[Anonymous]

Hi @mscopuser ,

Have a good day. Could you provide the expected output?

Best Regards,

Wearsky

[mscopuser]

Out put was amount per day in HH:NN:SS format. That has now been solved.

[FreemanZ · Accepted solution]

hi @mscopuser ,

try to write a calculated column like:

total time per day and projects column =

CALCULATE(

   SUM(data[Duration]),

   ALLEXCEPT(data, data[project], data[start date])

)

[mscopuser]

This is the code I use here for ref.

Total Time Projects = CALCULATE(SUM('Table'[Duration]),ALLEXCEPT('Table', 'Table'[Projects], 'Table'[Start Date]))

[mscopuser]

Thank you, I have tried this and this works perfectly.