Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Texas
    Posts
    2

    Angry Unanswered: Problem: Subtotaling hours

    I am having a problem on an invoice report where I have the timein and the timeout fields going to a calculated field with the formula:

    =Hour([Inv_timeout])-Hour([Inv_Timein])...thanks to this Forum.

    My Question is how do I take the results of that formula and sum the hours to be billed I am attempting to use the following:

    =Sum(Hour([Inv_timeout])-Hour([Inv_timein])) and am getting a
    #error as a result.

    I have been working on this problem for 2 days now I am about to pull my hair out.

    Thanks,
    DBwanttobe
    Last edited by DBwanttobe; 10-09-03 at 12:40.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    See: http://www.dbforums.com/t927476.html

    For some tips ... Basically you need to calc the minutes and convert to hours for your billing.

  3. #3
    Join Date
    Oct 2003
    Posts
    103

    Re: Problem: Subtotaling hours

    I would use subtot:(datediff("m",[inv_timeout],[inv_timein])*60)

    Originally posted by DBwanttobe
    I am having a problem on an invoice report where I have the timein and the timeout fields going to a calculated field with the formula:

    =Hour([Inv_timeout])-Hour([Inv_Timein])...thanks to this Forum.

    My Question is how do I take the results of that formula and sum the hours to be billed I am attempting to use the following:

    =Sum(Hour([Inv_timeout])-Hour([Inv_timein])) and am getting a
    #error as a result.

    I have been working on this problem for 2 days now I am about to pull my hair out.

    Thanks,
    DBwanttobe

  4. #4
    Join Date
    Oct 2003
    Location
    Texas
    Posts
    2

    Post

    Thank you for your replies but I have a TimeIn and TimeOut calculating the totalTime per detail line.

    Such as:

    TimeIn TimeOut TaskTime
    Task1 9:30 11:30 2.0
    Task2 12:30 3:00 4.0 (rounds up)


    Total Time: need to calculate
    Pay Rate: 20.00
    Invoice Total: Total Time*Payrate

    Thanks

    Getting closer
    Last edited by DBwanttobe; 10-09-03 at 20:18.

Posting Permissions

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