Forum Discussion
Ayudame1
Sep 14, 2023Copper Contributor
Excel Formula Help
I Need an excel formula to get total time spent in an account based on date, user, account number. example below of my table data time Account User Date 2:13 PM 123 A7 8/1/23 ...
NikolinoDE
Sep 14, 2023Platinum Contributor
In the "Time" column, is this the beginning of time? If so, where does the time end?
If it is the total time, why is it marked PM and AM?
If it is the total time, why is it marked PM and AM?
Ayudame1
Sep 15, 2023Copper Contributor
NikolinoDE the issue with the data report is it pulls start and end time in that one column under time.
I have been trying to figure out how to get the end time in another column quickly because of data can have have multiple times listed and the actual report I have is massive and would take forever to do it manually.