Calculation for Time In and Time Out form
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 ...
Forum Discussion
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)
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)