Excel - dropping zeroes from time

 Joe -

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"
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month