Hello,
I have a list of times (in order from first to last). I receive this data in a report each night, and it can often contain varying amounts of entries.
I would like to calculate the time between the first entry (in Q2) and the last entry at the bottom of column Q. The issue I'm having is that there can, and will be, blanks in column Q.
Can anyone please help?
Thank you.
I have a list of times (in order from first to last). I receive this data in a report each night, and it can often contain varying amounts of entries.
I would like to calculate the time between the first entry (in Q2) and the last entry at the bottom of column Q. The issue I'm having is that there can, and will be, blanks in column Q.
Can anyone please help?
Thank you.