Hi

As calculating time difference doesn't involve any functions, then you need
to enter the formula directly into cell. Select the cell, and type there in
something like this:
=13H-13D+(13H<13D)
(start with equal sign, adjust cell references accordingly your data)

You have to ensure before, that the cell you'll type formula in isn't
formatted as text. And after you entered the formula, you maybe have to
format it - any valid time format will do.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"John L" wrote in
message ...

Thanks Again,
I will be entering the times as...(example)..3:34 PM or 2:19 AM. Right
now if i enter a time without the AM or PM it puts in the AM for any
time i enter???

To enter the formulas that were given I click on the cell that I want
the answer to appear in, I go to " insert functions ". The insert
function box pops up. What do I pick from??

jOHN


+-------------------------------------------------------------------+
|Filename: FIRE CALL REPORT.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4813 |
+-------------------------------------------------------------------+

--
John L
------------------------------------------------------------------------
John L's Profile:
http://www.excelforum.com/member.php...o&userid=34774
View this thread: http://www.excelforum.com/showthread...hreadid=545361