I'm still struggling to calculate hours and minutes a user has worked for within the day and week and also calculate their travel time time as well.
There are actually two sets of daily work time, so worktime is the amount they worked for the day and daily work time is the total hours worked for the day excluding meal time. Travel time is just travel time and I want that when ever they pick the activity travel and also input the time they started it and ended it, it would calculate the hours and minutes that it took them to do that activity (travel).
If you can provide some formulas that you are struggling with, that would be best. Some samples of what you have (and the data) and what calculation you are trying to get to, would be helpful. Also and column names and/or controls that have any value you want to work with.
@RandyHayes Okay so the calculations I am trying to get is this:
There are two columns that need to be calculated:
1.Travel time (the time it took them to travel to an destination of work)
2. Work Time (the time it took them to do a job/activity)
3. Daily Work Time ( the time it took them to do all the activities in a day and then minus meal time which is usually 30 minutes) (also travel time is not included in this even though it's an activity)
As you can see from the image below each rows represents each day, the first row the first activity they started at 7am and ended at 10 am and the 2nd activity is travel and they started at 10 am and ended at 11am, so what will be calculated in travel time is the amount of time travelled which is an hour and the work time calculation will only calculated time of other activities not including travel and that sums up to 3 hours. Now the Daily worked hour is is all activities excluding travel summed up and then the meal time which is 0.30 is taken away from the calculated hours worked. So basically the only did one activity that isn't travel on that day and that means the calculated sum is 3hrs and then we take 30 mins of so the total sum of the daily worked is 2h30mins.
I haven't used a formula yet to calculate these sums.
Sorry for my delay on this one. Are you still having this issue or have you resolved it?
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks