Calculating Time Difference
I am trying to calculate the difference between 2 date/time fields and have it show up as 0 Hrs 42 mins or 1 Hr 15 mins
I have input the following based on a prior post, but it is not working:
((((((Date_Time2 - Date_Time1) / (1000 * 3600))).toLong())) + " Hours ") + (((((((Date_Time2 - Date_Time1) / (1000 * 3600))).toDecimal() - (((Date_Time2 - Date_Time1) / (1000 * 3600))).toLong()) * 60)).toLong())
The formula gets saved OK with any error, but no data is populating in the field, it is just blank.
I think I probably have too many or too little parenthesis.
Thanks in advance.