Calculated time between two columns in sharepoint list.

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

This is my SharePoint list,

Name	Date	Login	Logout
Dani	18/05/2021	18/05/2021 10.30 AM	18/05/2021 12.30 AM

Now i want to calculate a time between Login and Logout column and If it is not completed 5 hours need to display warning message "You are not completed 5 hours"

am using sum formula ,
Set(cal ,Sum(Last(List).Login ,Last(List).Logout));

But it couldn't work .

How to do this?

Thanks,

Dhinesh

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

rizkyaditya 292 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Dhinesh28R ,

How do you want to show the warning message?
For now i assume you click on a button, maybe the logout button.

You can try to use this for the OnSelect property :
If(DateDiff(Login, Logout, Hours) < 5, Notify("You are not completed 5 hours", NotificationType.Warning))
Dhinesh28R 599 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @rizkyaditya ,
Working good man.

Thanks,
Dhinesh