I am creating a weekly planner for an excel class that I am taking.
Each cell is in half hour increments. I have to plan out my week with work, school, homework etc.
I would like to total the time spent on each task.
Is there any way to give each individual cell a time value of 30 minutes, then create a formula to add all time spent on that task.
By this I mean if 9 cells that says "homework" would be 4.5 hours total.
I hope I am clear in my explanation. Any help would be appreciated.
Bookmarks