#1
|
|||
|
|||
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 |
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 a range of cells | Dave T | Excel Programming | 1 | 06-01-2016 08:58 PM |
Convert large seconds values to a time format fails with #Value | Sekerob | Excel | 3 | 07-18-2015 01:56 PM |
Procedure for displaying symbols for degrees, minutes, seconds | kinglaird | Excel | 1 | 01-17-2015 02:04 AM |
How-TO format cells (FILL) by comparing cells | zanat0s | Excel | 1 | 07-03-2012 04:27 AM |