formatting for periods of time

[Chris McLean]

I am using excel 2000. I want to be able to easily add up amounts of time,
such as the length of CD tracks, recorded in minutes and seconds. For
example, adding 7 mins 35 seconds, 10 mins 55 secs, etc etc and get the
total amount of time taken in minutes and seconds. Is there any way to
format cells so that this can be done easily? All of the formating relating
to time under "format", "cells" in both "time" and "custom" turn the entries
into clock time, and there doesn't seem to be anything that relates to
duration or 'elapsed time'.
Chris McLean

 

[Frank Kabel]

Hi
you can simply add these numbers if you store them as time. See
http://www.cpearson.com/excel/datetime.htm

 

[Nicky]

Hi
Converting times to date/time format is easy, either as a formula o
entering directly (1 = 24 hours so .25 = 6 hours etc).
These can then be summed using the usual sum functions.

However, to show sums of more than 24 hours you will have to change th
formula somewhat. The attached sheet shows possible solutions

Attachment filename: time example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52056

 

[DAVE TAYLER]

Try Custom Format and create your own as:

[H]:mm:ss

Regards - Dave the T.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Frank Kabel]

Hi
without looking at your attachment the easiest solution (IMHO) would be
to use a custom format like
[hh]:mm