I track the time spent on a task in hours (as number) and minutes (as number) . A person may have 7 entries in a month. I need to be able to show total hours and total minutes on the report per each employee.
Currently, i have a calculated field that takes my hours and converts them to minutes and then adds those converted minutes to the minutes field so i have maybe 910 minutes spent on that task for that person for the entire month. This should total to 15 hours and 10 Minutes. Currently my query shows 14 hours and 70 minutes and a total min of 910.
When i convert it using Mod 60 - i am getting the hours correct but the minutes are not reflected accurately.
I tried to use a function, CalcHoursOrMin that i found on the web, which works beautifully line by line but still does not give me a total per person for the entire month.
I am new to access - still learning not only the access interface but also VBA. I am pretty sure i am simply missing something.
Any help would be super!
Currently, i have a calculated field that takes my hours and converts them to minutes and then adds those converted minutes to the minutes field so i have maybe 910 minutes spent on that task for that person for the entire month. This should total to 15 hours and 10 Minutes. Currently my query shows 14 hours and 70 minutes and a total min of 910.
When i convert it using Mod 60 - i am getting the hours correct but the minutes are not reflected accurately.
I tried to use a function, CalcHoursOrMin that i found on the web, which works beautifully line by line but still does not give me a total per person for the entire month.
I am new to access - still learning not only the access interface but also VBA. I am pretty sure i am simply missing something.
Any help would be super!