Excel To Count hours more than 10000 hours

[thunder_anger]

Dear all

i got help yesterday from MrKowz that saved the day for me
but today there is a question, i know that it is silly but for sure i do not know how to do it

i am dealing with working hours for the annual report that must contain the total hours of work of about 5000 workers all over EGYPT in the branches of the firm i work for
so when i write this value (11253:52) Excel put it as text not like (5559:32) it recognize it as formatted time ([h]:mm)

what shall i do now

 

[barry houdini]

Sorry, that formula should work OK for your example....or where time values are 10000 hours to 99999 hours but, in fact, I should have suggested this one

=SUM(IF(ISNUMBER(A12:A150+0),A12:A150,RIGHT(A12:A150,7)+LEFT(A12:A150,LEN(A12:A150)-7)*10000/24))

to cover all possibilities