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: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
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