I think I'd try to make the time entries really times.

Maybe just selecting that range and
edit|replace
what: : (colon)
with: : (colon)
replace all

Would make excel see it as time.

Then you could just use
=a1+b1

Alternatively, you could try something like:
=a1+timevalue(b1)


Alan wrote:

I have another application that exports to Excel where column A has the
date and column B has the time. I want to be able to combine the two fields
in a 3rd field, say column C, where the time reads like it does when you
enter in the command =now(). The date format is correct, but the time comes
in text format, not time format.Can anyone help me with a formula that
combines the 2 cells to create a correct Excel formatted date & time cell??

TIA, Alan

--

Dave Peterson