Excel - Aproximate the min 30 or 00

April 9, 2009 at 03:40:06
Specs: Windows XP
have an Excel sheet with the time format 12:39:57 PM and i need to reset all the seconds to zeros and the minutes to be aproximate to 30 or 00 as the following :
10:39:57 = 11:00:00
12:18:40 = 12:30:00



See More: Excel - Aproximate the min 30 or 00

Report •


#1
April 9, 2009 at 09:02:12
Try this with your time in cell A1

=TIME(HOUR(A1),CEILING(MINUTE(A1),30),0)

MIKE

http://www.skeptic.com/


Report •

#2
April 9, 2009 at 15:43:28
Thanx alot for your help
it's working perfect

Report •

Related Solutions


Ask Question