hi
i am trying to calculate theamount o time between 2 time values

s25 = 05:59:59
t25 = 06:00:00

Q R
row 34 04:36:38 04:37:03
row 35 05:16:52 07:14:01


=IF(O34="Saturday",IF(AND(R34$T$25,R34<$S
$25),"06:00:00",TEXT(MOD(R34,1),"hh:mm:ss")),R34) returns 04:37:03



=IF(O35="Saturday",IF(AND(R35$T$25,R35<$S
$25),"06:00:00",TEXT(MOD(R35,1),"hh:mm:ss")),R35) returns
07:14:01

what i want is if the the time value in column R exceeds 06:00:00 the
time is replace with 06:00:00
this works for row 34 but not row 35

any ideas where i going wrong

thanks kevin