xcelnoobie924
New Member
- Joined
- Sep 14, 2023
- Messages
- 2
- Office Version
- 2021
- Platform
- Windows
Hello!
I'm trying to create calculate a formula that would grab the latest status update by project manager in Column. In case there are multiple records in the same day, I'd like to also include the m/d/yyyy hh/mm am/pm. K
Anyone have a formula that would work?
I'm trying to create calculate a formula that would grab the latest status update by project manager in Column. In case there are multiple records in the same day, I'd like to also include the m/d/yyyy hh/mm am/pm. K
Anyone have a formula that would work?
Weekly Status Report 2.xlsm | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
1 | Project Managers | Week Start Date | Week End Date | Update Time | Latest Update Time | ||
2 | Mikel White | 9/4/2023 | 9/8/2023 | 9/8/2023 9:43 AM | |||
3 | Cathy Rigby | 9/4/2023 | 9/8/2023 | 9/8/2023 11:47 AM | |||
4 | Jodi Hanke | 4-Sep-23 | 8-Sep-23 | 9/8/2023 10:43 AM | |||
5 | Andrew Thurman | 4-Sep-23 | 8-Sep-23 | 9/8/2023 12:20 PM | |||
6 | Jack Alexakis | 4-Sep-23 | 8-Sep-23 | 9/8/2023 4:47 PM | |||
7 | Michael Hauser | 4-Sep-23 | 8-Sep-23 | 9/13/2023 11:49 AM | |||
8 | Jeanne Wong | 4-Sep-23 | 8-Sep-23 | 9/13/2023 11:49 AM | |||
9 | Gary Waldon | 4-Sep-23 | 8-Sep-23 | 9/13/2023 11:13 AM | |||
10 | Terrance Ingram | 4-Sep-23 | 8-Sep-23 | 9/13/2023 3:11 PM | |||
11 | Terrance Ingram | 11-Sep-23 | 15-Sep-23 | 9/13/2023 3:45 PM | |||
12 | Andrew Thurman | 11-Sep-23 | 15-Sep-23 | 9/14/2023 11:40 AM | |||
Data |