Forum Discussion

RenPNW's avatar
RenPNW
Copper Contributor
Apr 16, 2024

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