Forum Discussion
How to track the project or task time in hours
Hello, in our company we are users of Office 365 and we want to manage projects through Planner. There is, however, a very important feature that I think is missing, a way to control the time in ho...
I see this is an old thread but thought I would put my two cents in if people are looking for a simple (but a bit crude) solution.
For a task that takes 8 hrs I simple add : Hrs 08 to the tasks name (obviously change 08 to whatever your duration is.
I then export the plan to excel and in a column I add the formula =RIGHT([cell with task name],2)+0 eg =RIGHT(B2,2)+0
the +0 removes a weird error that stops the SUM formula from working.
Use =IF( ) to select only the buckets, users etc or put it in a pivot table
If you don't like the Hrs: 08 in the task name put as the last checklist item or
as just the digits (e.g. 08) in the Description as the first two characters (or the first checklist item) and use e.g. =LEFT(P2,2)+0
For a task that takes 8 hrs I simple add : Hrs 08 to the tasks name (obviously change 08 to whatever your duration is.
I then export the plan to excel and in a column I add the formula =RIGHT([cell with task name],2)+0 eg =RIGHT(B2,2)+0
the +0 removes a weird error that stops the SUM formula from working.
Use =IF( ) to select only the buckets, users etc or put it in a pivot table
If you don't like the Hrs: 08 in the task name put as the last checklist item or
as just the digits (e.g. 08) in the Description as the first two characters (or the first checklist item) and use e.g. =LEFT(P2,2)+0
Daniel_NZ_AIL This worked like a charm. THANK YOU!
