Forum Discussion
RenPNW
Apr 16, 2024Copper Contributor
Difference of two Date/time columns to return only minutes.
What am I missing here to calculate strictly the minutes between two dates? This formula returns both hours and minutes, but I need it to calculate total amount of minutes only?
RoundDown(Text(DateDiff(DateValue20.SelectedDate+Time(Value(HourValue20.Selected.Value),Value(MinuteValue20.Selected.Value),0),DateValue19.SelectedDate+Time(Value(HourValue19.Selected.Value),Value(MinuteValue19.Selected.Value),0),TimeUnit.Minutes)/60),0)&" Hours : "&Mod(DateDiff(DateValue20.SelectedDate+Time(Value(HourValue20.Selected.Value),Value(MinuteValue20.Selected.Value),0),DateValue19.SelectedDate+Time(Value(HourValue19.Selected.Value),Value(MinuteValue19.Selected.Value),0),TimeUnit.Minutes),60)& " Minutes"
Thanks in advance!
Ren
No RepliesBe the first to reply