|
#1
|
|||
|
|||
How to make excel count based on time data?
Hello there!
I'm sorry to bother you all, but I've been having trouble for about a week now on how to make this work in Excel 2016 and couldnt find a solution yet... Here's what we got: There's a lobby where people going in and out, in the left group of columns. We got exact time of their arrival and exiting on the right (screenshot included). Is there any possible formula to make excel count how many people arrived, exited and visited lobby for every minute based on time data in the right columns? Like, if there's a 08:44:38 and 08:44:43 on Entry column, it means two people got in and Arrived on 08:44 and becomes 2 in cell, If there's 7 matches on 09:01 on Exit column, it means 7 people got out and etc... If you could help me out with this one i would really appreciate it! |
#2
|
||||
|
||||
crossposted and solution
How to make excel count based on time data? | MrExcel Message Board
__________________
Alan עַם יִשְׂרָאֵל חַי |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
count formula to count based on multiple criteria and return unique rows | Sphinxakop | Excel | 0 | 02-01-2023 12:18 PM |
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) | wvlls | Word VBA | 1 | 03-22-2019 02:29 PM |
How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
Vba macro code for grouping the data based on 2 hours time | dharani suresh | Excel Programming | 5 | 04-29-2014 03:25 AM |
How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |