How to track the project or task time in hours

Bruno Pereira  Like you, I need more granular planning capability.  I went ahead and got Project, which allows you to enter tasks with hour and minute granularity.  Even the Online version of that app can do a lot for building your planning.  However, it still falls a bit short.  I had to build flows that integrated with the calendars and with planner to make this give me something useful.

Plannner ---  This gives you a Kanban for loading up tasks, but is limited to DAY granularity; it won't do hour\minute and it won't give you a punch-clock.  A group calendar can be used a bit like a punch clock.

Project --- This has more granularity, and can be as granular as you like.  Unfortunately, it's difficult to build an assignable kanban board, though a basic one is available for sharepoint that will link to this.

Power Automate --- I used this to automate all three or link to other services.

I built my plan in project, a flow built a plan in planner, showing the start and end time of each item in the name of the task.  It also built calendar events on the group calendar for each task.  Another flow activates when a task is assigned or accepted from planner, and it adds the people to the required attendees.  This sends them an email and places it on their own calendar.  When they mark the task as completed, a flow runs that marks the end time on the event on the group calendar, sends me a notification, and puts the details from the newly updated event into an excel file.  Now I know how long it took.  There's a flow that runs a few days out, telling me which items are not yet assigned in an email.  When the items are about to start, everybody gets an SMS text from a texting service, letting them know where I need them to go to get started.  Checkin and Checkout are easy enough.  I have two task lists in the group mailbox.  Every time a new person is assigned a Task in planner or they accept it, their name gets pulled from contacts and added as the name of a task.  A single person checks them in and checks them out, so now I also have a head count going in and one going out.

For tasks that require multiple people, I have to cycle through multiple copies of the same task on the kanban in planner from project.  This gets handled in my Flow.

There are services like Trello and similar that get as granular as you like, and they connect with Microsoft services.  There's also a connector for Power Automate for creating Flow programs to fill the boards and grab data from their elements.  I'm currently waiting on the okay from the boss for the expenditure, but if I get it, our whole crew will switch to Trello, and I'll handle all the rest on the backend with Flows I've already built.  Ultimately, having the breakdown of how long they take and when they check in and out.  This gives me a breakdown of where our toughest work comes in so I can adjust crew teams, and I can pay them all for the day.  Those who don't check out with a text or by meeting the event personnel manager can be penalized if necessary (rarely, but mostly, I just match their data to the shortest time of the day that a person spent there).

Microsoft built a whole set of tools for similar operations each with extremely broad targets, but none of them hit every mark.

There are KANBAN connectors for Sharepoint that allow most users of SP to view tasks from Project Pro and accept them.  This creates a Sharepoint database with all the information necessary.  In Project, you can specify plenty of information in your tasks and you can set up templates.  I have a template in Project for a basic stage setup that I use for an outreach community performing arts charity, and it ties into a set of flows I keep a template for.  I simply change a few things like the date-time of the start and the duration.  Most of the rest is already set.