LinkBack URL
About LinkBacks
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?
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?
Last edited by diegosened; 01-25-2013 at 06:25 AM.
Try these..
=ROUNDUP($A$1*60*60*24/15,0)=ROUNDUP($A$1*60*60*24/10,0)=ROUNDUP($A$1*60*60*24/5,0)
Life's a spreadsheet, Excel!
Say thanks, Click *
thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks