Arranging time with excel

[diegosened]

Hello
I need help with a work.
I have to sort time into quarters, ten minutes and five minutes.
For example:
If I have 00:00:47 the result should be: 4 for the quarters, 5 for ten minutes and 10 for 5 minutes.

What do I have to do?

[Ace_XL]

Try these..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[diegosened]

thank you so much