Mod function with time formatted values

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

Try using quotes, i.e.

=MOD("0:16","0:0:30")

Thanks Daddylonglegs and it works.

Regards


kp