Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-23-2019, 10:37 PM
ArviLaanemets ArviLaanemets is offline Format cells to minutes and seconds Windows 8 Format cells to minutes and seconds Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

FormatCells>Custom: Into Type field enter the format.


You can also use formats like "[h]:mm:ss" or "[s]", but not "[d]" or "[d] hh:mm:ss".




The feature is available at least from year 2000, when I started to use MS Office instead of Quattro Pro and Visual FoxPro. But I'm not sure about web-based Office! I have MS Office installed in my computer.
Reply With Quote
Reply

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 02:49 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