Adding Time: What code should I use?

I have a string that contains a time in the 24 hour clock eg 0445

What code should I use to find out the time in 8 and half hours

Hello stoney1977,

Here is Worksheet Formula

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Another way is =TEXT(A1, "00\:00") + 8.5/24, and then apply the time format you prefer.