Forum Discussion
Calculate difference between two time and display the result in HH:MM format
I am looking for a measure which will give me the difference between Earliest StartTimeConverted and Latest EndTimeConverted.
** 7.92 hrs is the result which I am expecting here **
Note: STARTTIMECONVERTED and ENDTIMECONVERTED are field from a table. Here I have applied Earliest and Latest time for the field. So that I will be having only one row for each number.
1 Reply
- amitchandak
Super User
vimina , Simple subtraction should give time
[ENDTIMECONVERTED]- [STARTTIMECONVERTED]
