Recent content by wilde1

  1. W

    Multiply hours

    How can I mutiply the number of hours x the number of sessions i.e. format hh:nn * general number to return total hours used
  2. W

    Calculate hours

    Haved tried this but it keeps on giving me the number of records and not the number of hours i.e. it show 10 (which are the number of records) rather than 23 (number of hours used)
  3. W

    Calculate hours

    I have a form which shows me a total of hours used per person i.e. [time from]-[time to] i.e. number of hours used in a format of hh:mm. I have managed to calculate the total of each person but cannot seem to get my head around calculating all the number of hours for all the people in a...
  4. W

    Calculate hours

    I have created a query which gives me a total of peoples times i.e. [time from]-[time to], however I now need to total all these hours together. Do I have to do this in a query or can I put a grand total of hours directly into a form with some sort of expression? Do not know how to programme...
  5. W

    Calculate Hours

    I have typed in an expression [time from]-[time to] which then gives me a total of hours used per person (this done in a query) I have a grand total of hours in a sub-form for each person but do not know how to show a grand total of all the hours used. I also want to use this grand total in...
  6. W

    Calculate totals

    I have set up a form with a subform. In the subform I have a text box which has a calculation in it reading "time from" - "time to" which currently gives me a time difference between the times entered. I need to put on the bottom of the form (either main or subform) the total of all the hours...
Back
Top Bottom