Formula to sum times saved as text

[BakerUK]

I have an Excel report which indicates times in hh:mm:ss but formatted as text, and I'm looking for a formula that can sum the full range of them and display total hours.

TIMEVALUE seems to work for one cell but not the full range. Any thoughts?

Thanks
Baker

 

[wideboydixon]

=SUM(TIMEVALUE(A1:A1000))

Entered as an array formula with Ctrl+Shift+Enter. Change A1:A1000 to be the appropriate range.

WBD

 

[BakerUK]

Perfect!!!

Thank you.