discoverer 3.1 - calculations with hours/minutes
From: mh579 <mh579_at_bluecarrots.com>
Date: Thu, 11 Nov 1999 20:43:05 -0000
Message-ID: <382b2a64_2_at_news1.vip.uk.com>
I have produced an oracle discoverer 3.1 report based on manhours by person over a yearly period. The problem is that the information is stored on the oracle database as a number field. The user inputs the manhours taken as hh:mm with the mm being set to restrict no entry greater than 59.
Date: Thu, 11 Nov 1999 20:43:05 -0000
Message-ID: <382b2a64_2_at_news1.vip.uk.com>
I have produced an oracle discoverer 3.1 report based on manhours by person over a yearly period. The problem is that the information is stored on the oracle database as a number field. The user inputs the manhours taken as hh:mm with the mm being set to restrict no entry greater than 59.
Thew report retrieves the data as it was input ie 01:25 etc
but
when I wish to total the manhours for each person I can a calculated answer which is in error ie 01.55 + 02.15 = 03.70. I cannot get the answer to read 04.10hrs.
Could anyone please help.
thank you
martin hopkins Received on Thu Nov 11 1999 - 21:43:05 CET