Help with automation

[southcity]

Hello guys,
I really need help solving this, it would save me tons of hours.
I will explain what I need to do.

I have about 400 txt files that look like this: I did some notes with red text:

And I have to format this data so that it looks like this:

Like I said I have 400 text files which I need to get the TOTAL number only. So i only need to know the TOTAL number cell.
Can anybody help me to automate these steps? Or maybe you have another solution?

 

[KRice]

Do you have a couple of text files that can be shared? If so, sharing can be done by posting on any common sharing site (e.g., Dropbox, Box, Drive, etc.) and then share the link. If necessary, overwrite any sensitive information with something meaningless, but preserve the same spacing, structure, and character type (i.e., replace text with text and numbers with numbers). Is the one-page image posted representative of a single file, or are there multiple pages per file? Is the structure of every file the same? Put differently, if we looked at the 4th row of every file, would it begin with "Datum:"? And would the end of the data block of interest have an empty row below it?...and there are no other empty rows between those two potential demarcation locations?

 

[Anonymous1378]

If your files have a consistent delimiter and layout, the simplest way to approach this would probably be to get your text files into power query, and just group by your needed values column by the hour of day column.