Calculating time taken

[Microsoft]

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.

 

[mole999]

which formula dosen't account for blanks ?

Excel Workbook
	Q	R
1	*	*
2	12:34	01:09:00
3	*	*
4	*	*
5	*	*
6	12:48	*
7	*	*
8	*	*
9	*	*
10	13:43	*
Sheet1

 

[George J]

Mole, I couldn't get your first formula to work using Q:Q, but could when I put Q1:Q70
Not sure if this is a version thing - i'm still using XL2003 at home.

 

[mole999]

Mole, I couldn't get your first formula to work using Q:Q, but could when I put Q1:Q70
Not sure if this is a version thing - i'm still using XL2003 at home.

built in 2007, but I would have thought it might work

 

[Microsoft]

built in 2007, but I would have thought it might work

I am delighted to say that it does in fact work!

Thank you to both you, and George, for your help today