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
--
Ron Thetford