Excel - dropping zeroes from time

Joe - Jun 3, 2009 at 11:30 AM
 Joe - Jun 3, 2009 at 11:47 AM

I have a set of times in column A in Excel (HH:MM:SS). In column B I need those same times, not rounded, to have 00 as the Seconds value. Don't need a cell format change, need a true value change.

Example: 12:56:44 in Column A, need 12:56:00 in Column B


1 reply

Sorry, title should read" dropping seconds from time"