I have a set of data from a program that I export; and it varies in range. Sometimes there will be 9 cells in a column and sometimes, like, 40, for example. The very first cell in the column, when exported to Excel, is text that I don't need and the columns after the final populated cell are blank cells that I don't need. How can I figure out the time difference between the last populated cell and the first one?
When exported, the data in each cell (that isn't the first cell or a blank cell) looks like this:
4/25/2018 12:10:00 AM. Assuming column "B" is what I used, I tried the following formula:
=IF(B:B(ISNUMBER), (TEXT(MAX(B:B)-MIN(B:B), "hr:mm:ss")), "")
which (in my eyes) means "If the cells in B have a number, the difference between the max and min (latest and earliest) times will be found in hours:minutes:seconds, and the formula cell will be blank otherwise."
What am I doing wrong?