Good morning ,
I currently have a
Resource Check In Date - Date field
Resource Check In Time - Time of day
Resource Check Out Date - Date
Resource Check Out Time - Time of day
Total Hrs - Duration field ([Resource Check In Time]-[Resource Check Out Time])
Currently the results duration times are incorrect. How do i have it calculate the total hrs, and also anytime there is a checkin after midnight the results are a negative number. Also the results should roung to the nearest minute. The results are showing 8 decimal points (20.3333333333333 hours).
Hopefully someone can help me.
------------------------------
Dell Delemar
------------------------------
