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
Bookmarks