Has anyone made a spreadsheet that calculate time spend on each project based on tasks? Each project can have from 1-10 tasks, and each task can take from 30min - 4 hours. Some project is a one time thing, some could be as long as a year, and tasks could be as often as weekly or monthly. So, I want to create a spreadsheet that shows how much time we spend on each project and how much time/resource we have left.
Have anyone made a spreadsheet that calculate time spend on each project based on tasks? If so please send help! TIA!
2 replies