Calculation for Time In and Time Out form

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress

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

Photo of Roxanne

Roxanne

  • 120 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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...
Photo of Michelle

Michelle

  • 230 Points 100 badge 2x thumb
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.
Photo of Anna

Anna

  • 24 Points
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)

Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb
Thank you for the assistance, just another question? Have you done this formula for weekdays?