reset the seconds only to zero

April 7, 2009 at 21:31:58
Specs: Windows XP
i have an Excel sheet with the time format 12:39:57 PM and i need to reset all the seconds to zeros to be 12:39:00 PM in all cells

See More: reset the seconds only to zero

Report •


#1
April 8, 2009 at 05:15:25
Try this:

=A1-SECOND(A1)*0.0000115


Report •

#2
April 8, 2009 at 20:52:37
Thanks alot it's working

Report •

#3
April 9, 2009 at 05:24:37
After a little thought, I think a better formula to use would be:

=A1-SECOND(A1)/86400

since 1/86400 is 0.0000115740740740741 not 0.0000115.


Report •

Related Solutions


Ask Question