Xref: alice comp.databases.oracle.tools:35438
From: "mh579" <mh579@bluecarrots.com>
Newsgroups: comp.databases.oracle.tools
Subject: discoverer 3.1 - calculations with hours/minutes
Date: Thu, 11 Nov 1999 20:43:05 -0000
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <382b2a64_2@news1.vip.uk.com>
X-Trace: 11 Nov 1999 20:43:16 GMT, modem-157-1-60-62.vip.uk.com
X-Report: Report abuse to abuse@vip.uk.com
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!iclnet!news1.vip.uk.com!modem-157-1-60-62.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