Hi

if you like, send me your workbook ... julied_ng at hcts dot net dot au
.... be warned however, it is nearly 2am here so i won't be up for much
longer :)
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Metalteck" wrote in message
...
when I use the formulas you gave me
when the time differnce is 0:30, I get 0s in all 4 slots
In the fields that have no time in either start or end times, all columns
have 1's.