Can you help me please

"Hello, (sorry for my english which is not very good)

I would like to know how to add the time spent on each site per day. I record my times on a googlsheet using a mobile application (Tasker).

My data is saved like this:

-Site A: ““timestart”” —> ““Timestop”” ----> ““Total duration””

-Site B: ““timestart”” —> ““Timestop”” ----> ““Total duration””

-Site A: ““timestart”” —> ““Timestop”” ----> “Total duration”

-Site B: ““timestart”” —> ““Timestop”” ----> “Total duration”

I would like to know how to have a duration of site A and a duration of site B."

Thanks

@Anthony21
You can create a Virtual Column with an expression like this:

SUM(
    SELECT(
        TableName[Total Duration],
        [SiteName] = [_Thisrow].[SiteName] // Change the column name for [SiteName] as per your schema
    )
)
2 Likes

@LeventK
Awesome !!
Thank you very much for your help, this is exactly what I was looking for :grinning:

1 Like

You’re welcome

@LeventK
Sorry but I still have a problem that I cannot solve.

If I use my example

-Site A: ““ timestart ”” -> ““ Timestop ”” ----> ““ Total duration ””

-Site B: ““ timestart ”” -> ““ Timestop ”” ----> ““ Total duration ””

-Site A: ““ timestart ”” -> ““ Timestop ”” ----> “Total duration”

-Site B: ““ timestart ”” -> ““ Timestop ”” ----> “Total duration”

In my application after using the expression it looks like this:

Site A
Day 1: Total duration
Day 2: Total duration

Site B
Day 1: Total duration
Day 2: Total duration

But I would like it to appear like this:

Site A: Total duration
Site B: Total duration

Thanks