On Mon, 29 Aug 2005 19:53:12 -0500, BenjieLop
wrote:


StargateFan Wrote:
I've been fiddling and fiddling for some time now this evening but I
seem to be missing something completely today. In the past I've dealt
with adding/subtracting times formatted the same way as the end
results, so they've worked from the get-go.

In today's case, I have a spreadsheet that I'm using to calculate best
fits for movies transferred from VHS to DVD via a DVD Recorder. My
DVD Recorder deals with hours and minutes but my internet source gives
total running time in minutes only.

How do I get Excel 2000 to add up a column of minutes and then give
the results in a time formatted as hours and minutes? If I could get
this to work, I could then just plug in different movie running times
finding best fits?

Thanks! I'm in the corner with my dunce cap, I can't figure out my
approach today in a way that works. :oD

Assuming your minutes are entered, for example, in Cells A1:A10, the
formula

=INT(SUM(A1:A10)/60)&\" HOURS \"&MOD(SUM(A1:A10),60)&\" MINUTES\"

will give you the format of the answer that you are looking for.

Hope this will help you.

Thanks!

Regards.