Reading and Changing the information in Excel

[nacrane]

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 some help on how to sort the data. I have uploaded the document to this forum. 

Basically, I need to change the data so "Traveling, Working, Idle" are in one column and the WO# is in another column.. can something like that be automated? 

Then, I would like to create formulas that would total the amount of time "traveling or working" on WO#___. 

Please let me know if this is even possible! Thank you!! 

[#2]

@nacrane 

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")