![]() |
|
#1
|
|||
|
|||
|
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 |