Using a text function is OK if you just want to display it, but not
necesarily if you want to do calculations.

Some calculations, such as adding or multiplying, will translate the text to
a number, but functions such as SUM and AVERAGE will ignore text.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
If you want to get the difference between two times then use text
function.

Assume that C5 is the Start Time and C10 is the End Time.
C5 Cell
6:55:22 AM

C10 Cell
5:36:08 PM

=TEXT(C10-C5,"HH:MM:SS")

Myself is a learner so I hope that the experts will guide you about the
explanation you have asked for.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"geebee2k" wrote:

This is a simple question compared to some others here! :-)

I have come across a spreadsheet which does various calculations on time
values. The formula in question is:
=C10+(C10<C5)-C5

...where C5 and C10 are both time values (e.g. 9:30 PM). The formula
seeks
to determine the elapsed time between C5 and C10. Obviously, the
expression
(C10<C5) is a logical expression, and evaluates to such if it is entered
into
a test cell (it evaluates to "TRUE" in every case I tested.) The formula
calculates properly if this term is included, and does NOT calculate
properly
if it is NOT included.

I've never used logical expressions in an arithmetic formula. Can anyone
explain why the logical term is necessary, and how it works? I'm just not
comfortable passing the spreadsheet along without understanding how
everything works!

Thanks,
Geebee