Hi,

I need to work out if there is any residual time left using 30 secs interval. For example, if I have "0:16:00" in A1 and in B1 I have "0:0:30", in C1 I input the following formula which produces a correct result of 0:

=Mod(A1,B1)


I'm stuck in using this function without using the cell references? I tried to input =mod(0:16/0:0:30) but XL didn't like it. Any idea anyone?

Thanks in advance.

Regards


kp