Extract Minutes and Seconds from a time value

I have a formula that gives me a time value (ie 12:53). I need to perform another formula that will use this data but I need the numbers seperated (12 in one cell and 53 in another)

In essence, what would be the formula to pull off the minutes number and the seconds number into individual cells. I know anything is possible in Excel, I just can't figure this one out.

Hi,

use the MINUTE() and SECOND() functions with a time value as the argument. so, if your calculated time is in A1, you can get the minute portion by using

=MINUTE(A1)

and the seconds by

=SECOND(A1)

hth