Brian,
Thank you for the reply.
In the panel I have recording time as THMSZ9:99 and date as D99-99-9999
(one field for each)
I think what you have written means that I need to create another field (a
numeric field) to hold the number value of the time field and use that
numeric field in the report to total time. Is this correct?
I appreciate the information you have provided.
Victor Warner
On Wed, 12 Apr 2006 21:48:51 +0100, Brian Hancock
<[EMAIL PROTECTED]> wrote:
Hi Victor,
When you say date and time, rather than the time as in something o'clock
do you mean the time elapsed to perform the action? If the latter, are
you using a time field to record the elapsed time, a numeric field to
hold decimalhours, or a alphanumeric field to hold an hours:minutes
representation of elapsed time? How are you then trying to display the
results of the summation of the time elapsed fields.
Once summing the time, you cannot use a T field to represent the
outcome, because it is designed to roll over at 23:59 minutes, so you
would need to either use a numeric field to display decimal hours,
(after remembering to divide the time returned in seconds by he
summation by 3600 to get it back to hours). You might prefer to display
it as Hours:Minutes or similar which will require you to convert it back
to the numeric hours, and then manipulate the resultant number back to a
string representation of the format you require.
Regards
Brian
----- Original Message ----- From: "Victor Warner" <[EMAIL PROTECTED]>
To: "DataPerfect Users Discussion Group" <[email protected]>
Sent: Thursday, April 13, 2006 6:05 AM
Subject: Re: [Dataperf] Getting a total for a series of times which
extend 24hours
Ralph and Brian,
Thank you very much for the informative replies. Ralph, I had looked at
the material in your book, but did not seem to cover my problem (this
is most probably because I cannot define my problem adequately).
Perhaps I can define my problem again?
The panel which records the following information:
date, action carried out for a client, comments, time (plus a few other
entries not of relevance here).
Each time entry will always be less than 24 hours. The only difficulty
I am having is in the report when (in the final footer section of the
sub report mentioned in my previous post) I add the time field and from
the available options I choose sum. It is here that I am having the
problem.
The method in the book ("Calculating Elapsed Time Across the 24-Hour
Barrier") I think involves adding extra fields some which converts the
time field to a decimal. If this is what is required then I can use
that decimal field from the panel in the report to create the sum
without problem.
I would be grateful for confirmation that I have not misundestood what
I have been told.
Victor Warner
On Wed, 12 Apr 2006 15:40:28 +0100, Ralph Alvy <[EMAIL PROTECTED]>
wrote:
On Wed April 12 2006 3:42 am, Victor Warner wrote:
I am having difficulty in totalling a group of times which exceed 24
hours.
Take a look at the section in my book called "Calculating Elapsed Time
Across
the 24-Hour Barrier". It talks about the using what I coined the Moment
Function, which is what Brian is using here. The examples in that book
should
help you.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
-- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
