Getting the last minute from the minute() function

I can get the minute of 42341.9771299769 by using =minute(42341.9771299769); is it possible to get the last minute only of the minute? So if the minute is 5, output 5, if 9, output 9, if 13, then 3, if 28, then 8, if 45, then 5, an so on... Could use either a formula or VBA, whatever is easiest.

Thanks

This is a bit long winded, but it works...

	A	B
1	Thursday, December 03, 2015 23:27:04	7

B1=--MID(TEXT(A1,"m.s"),2,1)

or

=MOD(MINUTE(A1),10)

Thanks Siva, I knew I was over-complicating that

Ok, thank you both. Is there also a way to do this in VB? I tried using the Mod as a WorksheetFunction, but does not seem to work.

Mod is an operator in VBA:

myMinute = minute(someDate) mod 10

Great! Thank you.

You're welcome.