Excel - dropping zeroes from time [Closed]

Question

Excel - dropping zeroes from time [Closed]

Report

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

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

Excel - dropping zeroes from time
Excel duplicate rows n times ✓ - Forum - Excel
Excel duplicate row multiple times ✓ - Forum - Office Software
Excel if statement with time range - How-To - Excel
Excel repeat row n times - How-To - Excel
Excel drop down list with multiple columns - How-To - Excel

1 reply

Ask a question

Joe · Accepted Answer · 2009-06-03T11:47:20-0400

Answer 1 / 1

Joe
Jun 3, 2009 at 11:47 AM

Sorry, title should read" dropping seconds from time"

Excel - dropping zeroes from time [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!