On Fri, 10 Jun 2005 22:52:08 -0400, "Avery Wagg" wrote:

I'd like to add 10,311 hours and 20 minutes (10311:20), onto a calculated
time (in minutes), but I can't figure out how to turn this large number into
something excel can add time to.

Any hints?

..Avery


You have a problem.

The maximum time value that you can type into a cell is 9999:59:59. If you
type a value that is greater than or equal to 10,000 hours (10000:00:00), the
time appears as a text string.

The maximum time value that you can calculate using a formula is
71003183:59:59. This value equates to 12/31/9999 23:59:59, which is the maximum
time that you can use, at least in Excel 2002.

If you can operate within those constraints, perhaps by entering your large
times as two smaller times, and then summing them, that would be one solution.

Otherwise you will need to treat them as ordinary numbers and do the
appropriate math.

For example --

A1: your calculated time
A2: 9311:20
A3: 1000:00
A4: =SUM(A1:A3)

Format the cells as [h]:mm


--ron