Hi Victor,
Without specifically answering your question, dates and times are all
numbers. Date are whole numbers representing the ordinal day number since
1st March 1900 which in DP is day 1, today is day number 38758. Time on the
other hand is represented as seconds from midnight, so 10pm is represented
by the number 79,200 being 22 * 60 * 60 to convert to seconds.
You can therefore represent the combination of date and time by converting
the date to seconds, and then adding the time... so "right now" in seconds
would be represented by (today * 24 * 60 * 60) + now
10pm on the 1st of January 2007 would be represented by the number
date[1;1;2007] *24 * 60 * 60 + (22 * 60 * 60)
This can get to very big numbers ( 3,371,580,000 for the above) and can
screw with your head and your pocket calculator, so if you hate really bug
numbers, you can say deduct 2000 years worth of seconds to make more easily
managed, but just remember to apply this deduction consistently on all terms
in any comparisons.
Ok for comparison, just "normalise", for want of a better word, both date
and time sets and then you can easily deduct them from each other to get the
number of seconds difference, which can easily be manipulated into whatever
form you like. It doesn't matter whether they span 24 hour periods, or year
periods, the formulae always are the same.
I hope this helps
Regards
Brian
----- Original Message -----
From: "Victor Warner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 12, 2006 8:42 PM
Subject: [Dataperf] Getting a total for a series of times which extend
24hours
I am having difficulty in totalling a group of times which exceed 24 hours.
The database is structured so that one file (panel 1) contains the a field
stating the matter name for a client work carried. A second file (panel 2)
is linked to the first and records the dates and times against matters.
I have created a two-level report from panel 1 which has a sub-report to
panel 2.
However, within the sub-report I cannot get the total of time for a
particular matter when I use a report variable. I have created a report
variable to make the time a decimal number, but cannot work out how to
total this for the all times reported for a matter within the sub-report.
Help with this would be greatly appreciated.
Victor Warner
_______________________________________________
Dataperf mailing list
[EMAIL PROTECTED]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[EMAIL PROTECTED]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
