Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    4

    Unhappy Unanswered: Calculations with Time

    I've got two fields formatted as datetime in the table, a start time and an end time. In the report I have worked out the time spent ie =([start time] - [end time]). But what I want to be able to do is put a total time spent box at the end of the report, however access won't allow me to use the sum function on datetime, so I can't do =(sum([start time]) - sum([end time])). Any ideas?

  2. #2
    Join Date
    Dec 2002
    Posts
    18

    Talking

    Make a query calculating the used time per record (end time- start time) and then use the sum of that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •