Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Timesheet tracker Date and Time

Posted on by

Currently working on the Timesheet tracker by @RandyHayes . I have questions regarding dates:

  • How will it not reset the check in for the day? For example, my check in time is 9PM (July 7) then my check out should be 6AM (July 8). I would like the logic to be Check In shouldn't be available unless Check out has been clicked.
  • How can I add computation of hours? Check Out minus Check In. This is to get the rendered hours of the individual.
  • RandyHayes Profile Picture
    RandyHayes 76,308 on at
    Re: Timesheet tracker Date and Time

    @biancadevera 

    Well, the reality is, since you want not only that but also the multiple check ins and outs, that the architecture of that app is not really going to work for you.

    What I would recommend is to restructure it to always work with the LAST record recorded for the user that does NOT have a check out time in it - or a new one if none exists.

    The app was designed to do more of a record per day per user.  So with the above concept, you would instead have a record per check in/check out per user and the day is not relevant.

    That would give you the multiple check in/out ability and also cover the check out on another day.

  • biancadevera Profile Picture
    biancadevera on at
    Re: Timesheet tracker Date and Time

    Hi @RandyHayes 

     

    Thanks for the response. Could you please give me an example on how I could offset time? I'm also looking into possibility of multiple check ins/outs per day for employees who have flexible time. Would this be a challenge as well?

  • RandyHayes Profile Picture
    RandyHayes 76,308 on at
    Re: Timesheet tracker Date and Time

    @biancadevera 

    The sample Time Tracker app you are following was only intended to track daily times, not times that would cross the day boundary (i.e. 12 AM)

    You could implement an offset time on all of your calculations, to account for the day boundary, but it is a challenge to do.  

    So, in other words, the architecture of that app was very specific to just a day.  It would need to be adjusted completely for different periods of time.

    As for the hour calculations, some years ago I replied to someone on this forum with an app that does summing of all the people and hours from the app.  I'd hunt it down, but I feel it might not be worth it in this case since you really need to address non-day boundaries for check in/out.

  • Sunil-Narnaware Profile Picture
    Sunil-Narnaware 683 on at
    Re: Timesheet tracker Date and Time

    @biancadevera how are you capturing Check In and Check Out? What's the action?

    And for computation of hours use below formula.. replace with appropriate values for check in & check out..

    DateDiff( DateTimeValue('Check In DateTime Value'), DateTimeValue('CheckOut Date Time Value'),Hours)

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard