# Discussions

View Only

## 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?