Ah, I see. Of course. Thank you, Dave.

I do believe that it works because of what the CS folks would call
"type-casting" or "coercion," unless I am mistaken. In any case,
very nice soloution from DaddyLongLegs.

Dallman


In , Dave Peterson
spake thusly:

Without the +0, the value returned from the formula is a string. It'll look
like a time.

With the +0, you'll see a number. And if you apply the nice number format,
it'll actually be a time.

Dallman Ross wrote:

Very nice!

I don't follow the +0 at the end, though. I guess you
are expecting it to cause some sort of data coersion?
But when I leave the +0 off, the formula seems to work
equally well.

Dallman

--------------------------------------
In ,
daddylonglegs spake thusly:

You can also convert with this formula

=TEXT(A1,"00\:00\:00")+0

format result cell as hh:mm:ss