Skip to main content
Question

Calculation for Time In and Time Out form

  • June 23, 2017
  • 0 replies
  • 97 views
Forum|alt.badge.img+8

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

    This topic has been closed for replies.

    • MCFNeil
    • Registered
    • June 26, 2017
    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...
    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.
    • AnnaTamaoka
    • Registered
    • July 13, 2017
    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)

    • PaulVorster1
    • Registered
    • September 7, 2018
    Thank you for the assistance, just another question? Have you done this formula for weekdays?
    Terms & ConditionsAccessibility statement