Share via

Calculating nigth hours

VELEZ, CHRISTIAN O 0 Reputation points
2023-02-20T03:03:00.6+00:00

How can i separate nights hours from day hours in Sharepoint or PowerApp when for example employee started working at 4pm and finished at 12am, this will be 2hrs of days and 6 hrs with nigth differential. The PowerApp has 2 daytime pickers, (two datetime columns in sharepoint) with starting time and end time. Employee can work only 4hrs where 2hrs could be on days and the other 2hrs as nigth, so im not trying to do shifts. Also is not current time, this will be use to calculate a cost for a schedule request. Any help will be appreciated.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,230 questions
SharePoint Workflow
SharePoint Workflow
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Workflow: An orchestrated and repeatable pattern of business activity, enabling data transformation, service provision, and information retrieval.
641 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yanli Jiang - MSFT 30,791 Reputation points Microsoft External Staff
    2023-02-21T10:10:16.68+00:00

    Hi @VELEZ, CHRISTIAN O ,

    According to my research, your problem can be achieved by Power Automate, we suggest that you can go to the Microsoft Power Automate Community for professional help.
    Thank you for your support and understanding.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.