On Fri, 8 Apr 2005 03:57:04 -0700, Jay wrote:

It also equals 12. These are periods of time (durations from one to another,
Beginning to End) for a production process. They folks I work for decided to
use Excel and Excel does not seem to like these time values much. HELP!

Thanks again.




I think we need to know how these time periods are being entered and computed.

What you want to do seems simple enough, but if 00:00 represents a period of
time in Excel, it would ordinarily represent a multiple of 24 hours (including
0). If, in your template, it is representative of only 12 hours, there is
something going on that I don't understand.

How do you represent a production process that lasts more than 12 hours?

If you are entering start and stop times, or start and stop dates and times, to
compute and sum up a set of time periods is simple. I suspect you are having a
problem with either formatting, or with data entry.



--ron