Adding time in Excel

  m800afc 10:22 30 Jun 07
Locked

Being a bit old fashioned I still record music on cassettes occasionally. Until recently I had a utility that enabled me to enter the track times and then reorganised the times for best fit according to size of the tape, usually C90. I have not been able to find a replacement for this.
I thought of using Excel. I would like to enter times in the format mm.ss ie minutes and seconds as 3.55 = 3 minutes 55 seconds. I would then like to add all the times with an output in the same format. I could have two columns for a side and b side, and then juggle tracks so the two sides are the same length. I then lop off the unused tape and discard it. That way there are no silent passages of tape when using auto reverse players. Does anyone have any ideas for doing this efficiently?
Can I have the prize for being Luddite of the week?

  VoG II 10:27 30 Jun 07

You would be better to enter them in the format 3:55 which Excel recognises as a time. You can then add them up just as you would numbers. The only issue would be if the total time could exceed 24 hours in which case you would need to apply a custom format

[h]:mm:ss

to the cell containing the total.

  VoG II 10:28 30 Jun 07

Actually, use the format 0:3:55

  m800afc 11:44 30 Jun 07

Thanks for the advice. I have been using hh:mm:ss to enter the times, and formatted the cells to display mm:ss. Being a bear of very little brain I frequently forget to enter the hh as 00 and have to go back and correct, which is a pain in the fundament. Is there any way I can just enter mm:ss? As it is, if I enter what I consider to be mm:ss ie 3:55, it defaults to hh:mm:ss ie 03:55:00. Perhaps there may be a way of entering as degrees and seconds of arc?

  m800afc 11:45 30 Jun 07

I meant minutes of arc, but you probably guessed that :-)

This thread is now locked and can not be replied to.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…