Answered

Time Clock

(0) Share

Report

Posted on by Broly123

209

Hello! I created a time clock app in power apps and sent the "Punch In" & "Punch Out" data to share point. What would be the formula to show hours total hours worked?

What I have so far

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @Broly123,

You could use the following function in the Text property of a label:

DateDiff(startTime, endTime, TimeUnit.Hours)

Make sure to add a record reference before the column names (ThisItem, ThisRecord, record saved to a variable...)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
My apologies @Broly123, clearly missed the fact that this was about a calculated column in SP.

Give the following code a try in a Calculated number column:

=IF( AND( NOT(ISBLANK(endTime)), NOT(ISBLANK(startTime)) ), (endTime-startTime)*24, 0 )

I hope this helps!

Was this reply helpful? Yes No
Broly123 209 on at

Like (0)

Report
@LaurensM Thanks it worked! I forgot to mention a 30min break. Would the formula be something like?
=IF(AND(NOT(ISBLANK(endTime)),NOT(ISBLANK(startTime))),(endTime-startTime)*24-0.5,0)

And is there a way to calculate times for an entire week in sharepoint?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report

Hi @Broly123,

The formula looks good to me. 😊

What I would recommend regarding your last question is to start a new topic. I have a few ideas in order to achieve this, but I don't think they are best practice or the most efficient.

Other community members with more SharePoint expertise might be able to assist you here.

Was this reply helpful? Yes No
Broly123 209 on at

Like (0)

Report

@LaurensM Nice! Thanks a ton!

Was this reply helpful? Yes No
oyepanky 361 on at

Like (0)

Report

Hi Bro,

if you need any help with attendance related help, I already developed this application you can check out my videos on youtube.

link is here - Time IN And Out Button Create with Formula In PowerApps || Part-14
https://youtu.be/sFbAlSRD_qc

in this application these options

Check In - Check Out
Break options
Selfie option
location option
20+ option for employees & Manager login

please check out all parts
i hope this video help you.

Was this reply helpful? Yes No