Dear members,
i am having a time in format 03:22:42 in one cell.
i want to round off the seconds to 03:22:00
also i want to round off the minutes to 03:20:00 or 03:25:00
pls guide me.
Dear members,
i am having a time in format 03:22:42 in one cell.
i want to round off the seconds to 03:22:00
also i want to round off the minutes to 03:20:00 or 03:25:00
pls guide me.
You can use this for first one... =E2-TIME(,,SECOND(E2))
And this for second =MROUND(E4,"00:05:00")
For MROUND function if you haven't already done so, install the Analysis Toolpack add-in.
(Tools > Add-Ins...)
Last edited by zbor; 02-19-2011 at 04:52 PM.
Alternatively
andPlease Login or Register to view this content.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Or this for second one....
=MOD(E2-TIME(;;SECOND(E2));5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks