Share via

In TEAMS List how can I calculate # of hours available?

Anonymous
2024-08-15T15:23:27+00:00

I have a teams site that includes:

Project Name

Start Date

End Date

Allocation percentage

I want to be able to have the system calculate the number of hours based on the Start/End times the allocation percentage.

It should be something like this: June 1 - July 30 = June equals 20 business days time 8hrs + July equals 22 business days times 8 hrs

Total number of hours for the time period = 336

Allocation Percentage equal 50% (based on what is entered in the column)

Total time allocated = 168

Can TEAMs do this? What is the formula needed?

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-15T16:56:43+00:00

    Dear Geri Wales, Good day! Thank you for posting to Microsoft Community. I am happy to help you. I noticed that you want to use Lists in Teams. In order to test more accurately. If possible, could you please upload screenshot of List view with colmuns for our reference, so we can understand your exact scenario and provide our suggestion in a productive manner, perhaps some related screenshots will be helpful. I look forward to your reply. Thanks for your cooperation.Sincerely,Tin | Microsoft Community Moderator

    0 comments