Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 09-22-2019, 05:34 PM
NoSparks NoSparks is offline Format cells to minutes and seconds Windows 7 64bit Format cells to minutes and seconds 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
 

Tags
format cells



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2013 Messages can sit in the Outbox anywhere from 5 seconds up to 60 seconds BNS1968 Outlook 0 09-16-2016 08:07 PM
Format cells to minutes and seconds Format a range of cells Dave T Excel Programming 1 06-01-2016 08:58 PM
Format cells to minutes and seconds Convert large seconds values to a time format fails with #Value Sekerob Excel 3 07-18-2015 01:56 PM
Format cells to minutes and seconds Procedure for displaying symbols for degrees, minutes, seconds kinglaird Excel 1 01-17-2015 02:04 AM
Format cells to minutes and seconds How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft