Ron
As JE said in his earlier post, but substituting your ranges
=MOD(D2-C2,1)
copied down the range will return you the correct results

--
Regards
Roger Govier
"Ron Thetford" wrote in message
...
Here is a sample of the spread sheet
A B C D
E F
EMS4 unit TRANS HOSP time TRANS.TO
1 CA2004005787-1 M110B 21:11:53 21:31:22 0:19:29 PRESBYTERIAN
2 CA2004005820-1 M1113 10:19:00 10:35:00 0:16:00 BAYLOR
3 CA2004000010-1 M111A 5:05:36 5:17:35 0:11:59 PARKLAND
4 CA2004000055-1 M111A 9:44:27 9:53:09 0:08:42 ROBERT H
5 CA2004001173-1 M111A 23:54:06 0:05:25 ##### TRINITY

This is my formula =D2-C2 pasted all the way down the E column. As you
can see line on line 5 d5 is less thand c5 so I only get the ####. Need
to
know something about and if < then do this I think, but I am not sure.

Thanks again.