Hi,
I have this formula that calculates the difference in minutes between two Date/Time columns and it works great. The only issue is that I do not want any number to appear unless both Date/Time columns are updated by user. Not sure how to handle that or what to add to formula to accomplish that?
RoundDown(Text(DateDiff(DateValue19.SelectedDate+Time(Value(HourValue19.Selected.Value),Value(MinuteValue19.Selected.Value),0),DateValue20.SelectedDate+Time(Value(HourValue20.Selected.Value),Value(MinuteValue20.Selected.Value),0),TimeUnit.Minutes)/60*60),0)& " minutes"
Thanks in advance for any guidance on this!
Ren