I'm not sure I'm describing it right by describing this operation as a modulus, but I have a cell with a time value (e.g., 14:50) and I want to do the following:
  • round it down to the nearest 20-minute increment (in this case, 14:40)
  • populate a 2nd cell with the remainder after that rounding has been done (i.e., 0:10)

Thanks in advance.