Discussions

Expand all | Collapse all

Calculation for Time In and Time Out form

  • 1.  Calculation for Time In and Time Out form

    Posted 06-23-2017 16:34

    I have 3 fields

    Time In ( time field)

    Time Out ( time field)

    Total Time (Duration field)

    I want it to convert to amount of time spent at work

    Time In 10am Time out 2 pm = total time of 4 hours

    I put this in and it tells me -8.00

    My formula is ([Time Out]-[Time In])

    I have tried turning this around and or adding Sum before the formula - nothing is working to give me an answer of 4hrs



  • 2.  RE: Calculation for Time In and Time Out form

    Top
    Contributor
    Posted 06-26-2017 03:35
    This seems rather odd.  Its hard to say what might be causing this.

    Can you share some screen shots of the fields and formula.  I really don't know, but maybe we'll see something...


  • 3.  RE: Calculation for Time In and Time Out form

    Posted 07-12-2017 20:22
    Are you sure you entered AM for Time In and PM for Time Out? If it's getting -8.00, then it could be that they are entered either both AM or both PM.


  • 4.  RE: Calculation for Time In and Time Out form

    Posted 07-13-2017 16:50
    Just confirming that these are Date/Time fields and not just Time fields (I assume they are because I don't think there is a "Time" type option). I have a similar table where users enter a start date/time and an end date/time and it calculates duration, but you have to specify the date:

    Result:


    Setup:


    Duration formula:
    [End Time (Date / Time)]-[Start Time (Date / Time)]

    Fields (both Start and End time fields are set up the same way)



  • 5.  RE: Calculation for Time In and Time Out form

    Posted 09-07-2018 09:57
    Thank you for the assistance, just another question? Have you done this formula for weekdays?