Unfortunately that did not work. I tried it and when FALSE it still
displays the # VALUE error instead of the contents of cell B1. Looks
like I will have to insert 2 columns, do the TEXT first and then do
the IF statement.

D1 is still formatted in such a way that it is not compatible with A1
so I cannot go A1-D1. Manual formatting does not impact it.


On Mar 17, 1:47*pm, ryguy7272
wrote:
="0"&TEXT(A1,"hh:mm:ss")
or
="00"&TEXT(A1,"hh:mm:ss")

Then take the result and format as such:
=TEXT(A2-A1,"h:mm:ss")
or
=(MOD(A2-A1,1)*3600)/3600

That will show the number of minutes elapsed.
Does that work for you?

HTH,
Ryan---