Timesheet Value Error

(0) Share

Report

Posted on by LauraGrimes123

I have created a timesheet in which I need the users to enter a start time and end time, and then calculate the total hours worked - the function it self is working fine but when the user is typing in the times they are receiving this error and I would like for them to not get it - any ideas?

The code in the Total Hours Worked:

(DateDiff(
           DateTimeValue(starttime.Text),
           DateTimeValue(endtime.Text),
            TimeUnit.Minutes
        )) / 60
 
 

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey

can you maybe try this code:

If( !IsBlank(starttime.Text) && !IsBlank(endtime.Text), (DateDiff( DateTimeValue(starttime.Text), DateTimeValue(endtime.Text), TimeUnit.Minutes )) / 60, 0 // Default value when either Start Time or End Time is empty )

if it worked please mark as verified answer,

cheers