Hello,
I have 3 engines that I can export operating data into .csv format. I have been trying for weeks with no luck to easly and repeatedly change the hourly data into one daily row. I have attached a copy of the data that I download from a unit that has been changed to .xlsx.
As you can the the first column is the date and time. Each compressor day starts at 7:00am instead of midnight. Which means the daily average needs to run from 7:00am one day to 6:00am the next, Column B is the running total engine hours. On Column C I will need the max for the day, and then copy the corrisponding data beside it, and move all of this information onto another sheet to be listed as so:
Date | Daily Hours | Discharge Press | Discharge Temp | Suction Press | Suction Temp |
Please explaine how the formula's work when you answer. I really am trying to learn Excel.
This seems like it should be so easy, but I am about ready to pull my hair out over it. Thank you many times over to whomever can help me.
Bookmarks