Forum Discussion
Schledorn
Jan 10, 2025Copper Contributor
Need Formula Help
I have a table of phone activity for agents that I need to create charts from. I have another table for a chart to extract Log In and Log Out times for each day. I don't know what formula to use th...
Harun24HR
Jan 10, 2025Bronze Contributor
Your question little bit unclear. When you say in/out time for an agent for a day then you need at least agent name, date and in/out time. There may multiple logging means first one is in and last one is out. Times are store as decimal numbers in Excel. So, we can use MIN(), MAX() functions to get those in/out times. See the sample file and let us know your feedback and also attach a sample file to make the question clear. Also show your desired output manually in sample sheet so that we can make that output by formula.
=DROP(GROUPBY(A2:B18,C2:C18,HSTACK(MIN,MAX),0,0),1)