Extract & Sum Time from text

[jose.gnr.luis]

Hello all,
I've got a column full of data. Some cells has a time in format HH:mm plus the word 'Hi'. Other cells, just random texts.

Example:

A1 = 01:00 Hi
A2 = Chair
A3 = 02:30 Hi
A4 = Table
A5 = Dog
A6 = 00:30 Hi
A7 = Bill Gates
A8 = Excel Forum
A9 = 04:00 Hi

In A10, I'd like to extract the HH:mm from those cells, the onces that says Hi, and sum them all.
So in A10 I'd like to have: A10 = 08:00
(01:00 + 02:30 + 00:30 + 04:00)

Is there any way to do this without a macro?

Thank you all.

[Phuocam]

Try this:

=SUM(IFERROR(--LEFT(A1:A9,5),0))

Array formula, enter with Ctrl+Shift+Enter

[jose.gnr.luis]

Try this:

=SUM(IFERROR(--LEFT(A1:A9,5),0))

Array formula, enter with Ctrl+Shift+Enter

You're the greatest. Thank you, it worked!