Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-22-2019, 06:32 AM
RonDBD RonDBD is offline Format cells to minutes and seconds Windows 8 Format cells to minutes and seconds Office 2010 64bit
Novice
Format cells to minutes and seconds
 
Join Date: Oct 2013
Posts: 24
RonDBD is on a distinguished road
Default Format cells to minutes and seconds

I am tracking the songs on an album. There is a time per song in minutes and seconds. I want to format another column to contain a running sum of these times, in minutes and seconds. There is a predefined format for 13:30:55, but this requires the presence of hours in the length of a song. If I set the length of a song to 13:30:55 format with no hours present, it sums as hours and minutes.


Another way of phrasing the question ..is it possible to set a custom format for time?
Ron
Reply With Quote
 

Tags
format cells

Thread Tools
Display Modes


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 04:29 PM.


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