cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: Total Time calculation between value and drop down item

@mdevaney  I've tried the expression:

 

Text(Time( DateDiff(dtFrom.SelectedDate + Time(Value(HourStart.SelectedText.Value),Value(MinuteStart.SelectedText.Value),0),dtTo.SelectedDate + Time(Value(HourTo.SelectedText.Value),Value(MinuteTo.SelectedText.Value), 0), Hours), Mod(DateDiff(dtFrom.SelectedDate + Time(Value(HourStart.SelectedText.Value),Value(MinuteStart.SelectedText.Value),0),dtTo.SelectedDate + Time(Value(HourTo.SelectedText.Value),Value(MinuteTo.SelectedText.Value), 0),Minutes),60), 0) - Time(DataCardValue8_1, 0),- Time(Value(Left(DataCardValue8_1.Selected.Value, 2)),Value(Right(DataCardValue8_1.Selected.Value, 2)),0), "hh:mm")

 

and I'm getting an error message -

 

Expected text. We expect text at this point in the formula. This error occurs if you use a function that requires a text (or string) argument and you supply, for example, a date instead

 

Location

DataCardValue5_1.Text

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020 Winner Announced

Check it out!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (11,591)