formatting for periods of time

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

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
 
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
 
Hi
without looking at your attachment the easiest solution (IMHO) would be
to use a custom format like
[hh]:mm
 
Back
Top