Forum Discussion
Reading and Changing the information in Excel
Hey guys! My first post here and its kind of a loaded question.... I just started using a new program to track employee's time entries. I am exporting the information into Excel and am needing s...
Definitely possible
See if the attached is the result you're seeking.
To extract the WO# I used the formula =IFERROR(MID(C3,FIND("WO",C3),7),"")
To extract the nature of the activity, =IFERROR(LEFT(C3,FIND(" ",C3)-1),"")
Then got a list of unique WO#s with
=SORT(UNIQUE((I3:I45)))
Then to sum the minutes (I used your calculation of minutes) working or traveling
=SUMIFS($F$3:$F$45,$I$3:$I$45,L3,$J$3:$J$45,"Working")
=SUMIFS($F$3:$F$45,$I$3:$I$45,L3,$J$3:$J$45,"Traveling")