Adding Time in a Numeric World

[Joseph Rosenblatt]

I am running PH v 8.09 on an HP e3000 979/200 with MPE 5.5 PP 7.
I have a field called TIME defined as numeric 4 with a picture of "^^:^^".
It has two defined components: HOURS numeric 2 and MINUTES numeric 2. It is
itself part of a larger element DATE-TIME numeric 12.

My problem is that I want to subtotal the TIME field. Since this field is
numeric it works in decimal. Since time is not really a function of base 10,
I have a problem. I have tried SUBTOTALing the minutes and hours separately
but this does not help.

Short of redefining this element as DATETIME  data type (and I don't know if
that will help) how do I SUBTOTAL these fields?

Thanks for any help.

Joseph Rosenblatt

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.