Excel - dropping zeroes from time

Closed
Joe - 3 Jun 2009 à 11:30
 Joe - 3 Jun 2009 à 11:47
Hello,

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


Thanks
Related:

1 response

Sorry, title should read" dropping seconds from time"