Cell Format

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I need to format a column of cells to contain a duration of time (ie. the
length of a song such as 4:39) so I can total the column and get an Hours,
Minutes and Seconds result but the only format I can find will display this
a 4:39 AM.
Can anyone help?
Thanks
 
Hi

4:39 AM is 4 hours 39 minutes. Which is 60 times what you want (unless your
songs are hours long that is :-).

Select the cells, go menu Format > Cells, select Custom and enter [m]:ss in
the text field. Note that you still have to enter time like h:m:s ; 0:4:39 ,
or you'll end up with 4 hours 39 minutes.

HTH. Best wishes Harald
 
Back
Top