How to find a total duration in particular date?

AppSheet AppSheet Q&A
,
1

I have Timestamp column,
1 row will be in record and second row will be out record.
Like in and out.
I need the total duration of particular date.

ex–
1)1/10/2024 10:55:41 AM
2)1/10/2024 11:02:33 AM
3)1/10/2024 11:14:20 AM
4)1/10/2024 12:30:22 PM
5)1/10/2024 1:11:35 PM
6)1/10/2024 3:41:17 PM
first one is in timestamp, second one is out timestamp, its repeated all rows

2

Hi,

My suggestion :

Add two columns : Type and Day

Day formula is TODAY()

Create a slice and two views for In and a slice for Out entries. So that you can use in Type formula : if(Context(“View”) = “InForm”, “In”, “Out”)

Then calculates the duration for each day with: totalhours and select()