TIME (adding hours and Minutes to a time)

Please see the attached workbook so you can better see what I am trying to do but here is a brief summary:

I have a starting time, say 13:00 (or 1:00 pm) in B8
I need a formula to get the ending time in "C8" if I want to add the duration (3.45 or 3 hours and 45 minutes) from D8.

here is a quick screenshot so you can see what i am trying to do
\1

In that screenshot i can get what i want to work if i separate the hours and minute duration into separate cells. The issue is that I need it to work from a single cell (thus example 2).

Thank you to anyone who can help?

Try in C8:

=B8+SUBSTITUTE(TEXT(D8,"0.00"),".",":")

Or try:

=B8+TIME(INT(D8),MOD(D8*100,100),0)

Originally Posted by Phuocam

Try in C8:

=B8+SUBSTITUTE(TEXT(D8,"0.00"),".",":")

That did it. Your a gentleman/woman and a scholar. Thanks a million !!!!