Getting minutes from the time serial number

[USAMax]

I am trying to calculate the minutes from a cell after removing the hours. This formula should work but the results are wrong.

Formula I am using:
=INT(((I7 * 24) - INT(I7 * 24)) *60) & " mins"

If cell I7 has 8:04 I get, "3 mins"

If cell I7 has 8:00 I get, "-1 mins"

This should be simple so what am I missing?

 

[Marcelo Branco]

Try

=MINUTE(I7)

M.

 

[USAMax]

To darn easy,

Thank you Marcelo!

 

[Marcelo Branco]

To darn easy,

Thank you Marcelo!

You are welcome and thanks for the feedback.

M.