Thread: Format cells to minutes and seconds
View Single Post
 
Old 09-22-2019, 05:34 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
You can change the times directly in the C column using VBA,
but if you want a formula solution in column D, try this in D1 and drag down
= TIMEVALUE("00:" & HOUR(C1) & ":" & MINUTE(C1))
Reply With Quote