Data Calculations questions

From: Nangel (anonymous_at_discussions.microsoft.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 06:09:47 -0700

I am creating a report in access. The report contains two
fields; Start time and end Time. I would like to subtract
the end time minus the start time to give the total number
of time between the two fields with the following format:
dd:hh:mm:ss

Please advise how to accomplish this. If this is not
possible in Access, Please provide information on the
different types of calculation capable of doing with a
date field.

Thank you in advance for your help!

Relevant Pages

  • Re: Sum not recoginzing a negative number
    ... Now subtract 3 hours. ... Multiplying by -1 ... >>>I have a report in which I am attempting to calculate elapsed time. ... In my report I group the two events by day and sum them ...
    (microsoft.public.access.reports)
  • Re: Percent on sum total
    ... The problem is that the report will be run from data that already exists ... formula to some how filter one country from the other on the report. ... Then just multiply InvAmt by that value to get what you requested... ... then subtract that value from InvAmt.) ...
    (microsoft.public.access.reports)
  • RE: Subtract on a report based on QRY cross table
    ... "Duane Hookom" wrote: ... cross tab query, this one, the sub report, i would like, on Total, to show ... what i would like is to subtract both records on my crosstab report ... ... PlusMinus field in "a table with those accounts only with groups number" that ...
    (microsoft.public.access.reports)
  • Re: Percent on sum total
    ... I receive an error when running the report as if it is looking for a macro ... formula to some how filter one country from the other on the report. ... In whatever table you capture the InvAmt, add a new field called Rate ... then subtract that value from InvAmt.) ...
    (microsoft.public.access.reports)
  • Re: conditional formatting with time values
    ... Depends upon what way you want to subtract, is 12:00-09:00 3 hours or 21? ... >> My goal was to compare the 2 times and show if the report was alloting ... but I want to put in conditional formatting so that when the ... >> Alloting enough time The value is Yellow. ...
    (microsoft.public.excel.misc)