HELP! Calculating times
Help Gurus!
I’ve created a log sheet to log contact time of students on tasks. I need to add up/SUM the total time of their activities. This is highlighted in PURPLE.
Row D is a drop down menu of tasks, Columns E – J they need to log their time on these tasks, in 5min increments. This is highlighted in YELLOW.
How do I SUM these times?
There will be times where we will need more then 24hrs as well...
I’ve included the spreadsheet as well.
Thanks,
QueenMab
I see no highlighting in your file. Did you attach the correct file?
Also, there is no data in that file at all.
I would suggest that you add some sample data and some expected outcomes.
(note: enter times in TIME format, and dates in DATE format. That 1 date you have in there is text, not date)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Re: HELP! Calculating times
Do you just want the Times to round up or down to the Nearest 5 min
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks