Excel: Calculating time taken

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.

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of June 11, 2017.

For more resources for Microsoft Excel