DellDelemar
Qrew Member
Joined 2 years ago
User Profile
User Widgets
Contributions
Duration in minutes only
I have a duration formula below: Currently it shows the results in hrs or days. Anyway to have it show hours only and not days? var datetime CheckIn = ToTimestamp([Resource Check In Date], [Resource Check In Time]); var datetime CheckOut = ToTimestamp([Resource Check Out Date], [Resource Check Out Time]); $CheckOut - $CheckIn ------------------------------ Dell Delemar ------------------------------3Views0likes1Commentdropdown option reveals additional fields
I have a dropdown option for a Resource to add additional helpers. Dropdown field: " How many helpers?" the choices are 1-5. Depending on what number they select, is there a way for it to show that many additional fields of "Helper name" and "helper total hours"? So if the resource selected 2, then 2 additional fields will show so they can input the 2 helpers names and hrs worked. I can just add 5 additional fields for names and hrs, but if they are empty they take up too much space. ------------------------------ Dell Delemar ------------------------------13Views0likes1Commenttime duration
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 ------------------------------41Views0likes5Comments