Forum Discussion
MCFNeil
9 years agoQrew Captain
Create a formula-duration field. Insert this formula. This is assuming your start and end date/time fields are called [Start Date] and [End Date], respectively.
# of Weekdays + # of hours in 1st Day + # of hours in the last Day - 1 day to balance the ends
This excludes weekends, and assumes your "time" is between 8 am & 8 pm. If you are going to have times outside of those windows we'd just need to put some conditions on that part.
Let me know if you need more, but I'd like to know what you are going to use these durations for? What are you timing out of curiosity?_
# of Weekdays + # of hours in 1st Day + # of hours in the last Day - 1 day to balance the ends
Days(WeekdaySub(ToDate([End Date]), ToDate([Start Date]))) + (ToTimeOfDay("8 PM")-ToTimeOfDay([Start Date])) + (ToTimeOfDay([End Date])-ToTimeOfDay("8 AM")) - Days(1)
This excludes weekends, and assumes your "time" is between 8 am & 8 pm. If you are going to have times outside of those windows we'd just need to put some conditions on that part.
Let me know if you need more, but I'd like to know what you are going to use these durations for? What are you timing out of curiosity?_