Excel - dropping zeroes from time [Closed]

 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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!