Newbie needs help with sorting data by latest time and multiple categories

Hello,

I am fairly new with using Excel beyond the basic spreadsheets, however have decent computer skills. I have no formal training but grew up with computers and have taught myself along the way to figure out how to do what I want, basically if I don't know how to do something I scour the internet for examples. I have been playing with formulas and a little vba here at work trying to create some spreadsheets to assist our manufacturing areas in data sharing. I have searched the net trying to find an example and have got a start, however am currently stuck. Without being too specific here is what I am trying to do.

1) There are multiple "cells" with multiple machines that produce parts. I am in the area that inspects these parts and am working on coming up with a better way of tracking data for them.
2) I have attached (I think) a sample of what I have so far. I removed it in the sample, however have added a data connection to pull in information from another (.txt) file that has all of the information needed. (Date of report, Time of report, "cell", Machine number, etc.)
3) I added some VBA code to auto-generate a link, used the "now" function to compare the current time and the time that our inspection was complete, in the goal of getting an elapsed time since the part was checked. I am having some real issues with the elapsed time.
4) Here is where I would like to go with this set-up.
a) Have a "parent" sheet/(workbook preferably) that pulls in all data and information described below.
b) Have sorted "offspring" sheets/(workbooks preferably) with the only the data from the "machines" that are in that "cell". I would like this workbook to display each of the machines in the cell and the last time a report was generated. (basically an easy way for "them" in the cell to know what "parts" they need inspected, based on the last time we checked them) This can hopefully be done with a filter that can be removed to show older report times also.
Sorry about my scatter brain but I have a lot going on in my life right now...

My first hurdle:
I am having some issues getting the Time elapsed to work the way I want it to. I would like to also check against the number of days since the report was created and after "x" amount of days to not display the time elapsed, just the days. Multitasking right now so I am having some trouble wording this so here is an example:

Let's say current time is Today at 2:00pm and a part was checked yesterday at 1:00pm. Using my current set-up I get a Time elapsed value of 1:00, when it should be 25:00. I am sure there is a perfectly clear solution to this that I just cannot figure out due to my limited experience.

My next struggle:
Sorting the data based on filtering by "cell", then showing only the last data for each machine.

Finally after I get this to work (or maybe this needs done during the other 2)
I would like to get the "parent?" and "offspring?" sheet thing down, preferably the "parent" sheet would be open for edits, by me or individuals in my department, and the "offspring" sheets would be in a read-only format. (only if this would allow the vba code to update the time as I have programmed it to, and allow them to double click on the "LINK" cell that would take them to the data)

I started typing this on my lunch break and finished at home and am hurried as I have other things to do, so I know I will leave out some very simple information that will make me feel at myself, so I apologize in advance.



UPDATE: I have attached the correct file now, if there 2 files attached the one I need help with is called "example_of_attempt"
Example_of_attempt.xlsm