Thank you for your reply. I tried the =B2-B1 + (B2<B1) and the mod command,
but neither seem to work. I am not very strong with formulas in excel, so I
can just tell you I copied and pasted you first example into the cell then,
modified the letter to match with the at hosp time minus the enroute to hop.
I did not understand if I need to do somehting about the true/false part of
the statement. Thanks again.
--
Ron Thetford


"JE McGimpsey" wrote:

XL stores times as fractional days, which means that 03:00:00 = 0.125
and 21:00:00 = 0.875, so "later" times can be numerically less than
"earlier" times if the times span midnight.

One way to work around this is to add 1 if the later time is less than
the earlier time. Using XL's implicit coercion of boolean TRUE/FALSE to
1/0:

=B2-B1 + (B2<B1)

another is to use the slightly more obscure MOD function:

=MOD(B2-B1,1)

In article ,
Ron Thetford wrote:

I have data from our public safety system I download straight into Excel. I
have two colums of time in the following format: 00:00:00 Of course this
is just the format it comes in as. I have for example 11:50:00 in cell A and
12:00:00 in cell B
I know I can say cell C is =(B2-B1). This works on most records but I have
the occasion where cell a is greater than cell B: Example Cell A "23:59:00
and Cell B is 00:12:00. This is cell A equals the time a ambulance left the
locaiton of a call enrourte to a hospital. Cell B is when they get to the
hospital. I need to somehow add back in 24:00:00 if cell B is less than cell
A. ( I think). Anyway I am by no mean anywhere near a lot of experience in
Excel. I think I could use it alot for reprot on the public saftety side,
but I need to pick up a lot of info. Any help is greatly appreciated. Thanks