LinkBack URL
About LinkBacks
Dear members,
i am having a time in format 03:22:42 in Cell A1
i want to round off the seconds to Minute as 03:23:00 to Cell A2
Even if one second is exceeded, i want to round off the time to next minute 03:22:01 to 03:23:00
pls guide me.
Time Round off to next minute Formula
Dear members,
i am having a time in format 03:22:42 in Cell A1
i want to round off the seconds to Minute as 03:23:00 to Cell A2
Even if one second is exceeded, i want to round off the time to next minute 03:22:01 to 03:23:00
pls guide me.
can you try
=ROUNDUP(A1*1440,0)/1440
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Another option to achieve this.......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thank you Vlady..!! It Worked.!!Originally Posted by vlady
How to get the current system time with seconds in the Cell A1, but at the same time the value in cell should not vary later??
pl. suggest
Tried with Ctrl +Shift + : (colon)
-- seconds are not captured here
Tried =Now() option
-- I do get the current time here but it varies as time progresses
You'll need vba/macro to do that.
here's one link.
http://www.excelforum.com/excel-gene...populated.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks