Hi All,
I have written the following expression on RDLC Layout of a report to display the time which is originally in decimal format to HH:MM:SS format. But it it displaying only hours and minutes and seconds are being displayed as 00. Please suggest the correct expression if I am making any mistake:
=Floor(Sum(Fields!Actual_Time.Value*3600) / 3600) & ":"& RIGHT("0" & Floor(Sum(Fields!Actual_Time.Value *3600)/ 60) - Floor(Sum(Fields!Actual_Time.Value*3600) / 3600) * 60, 2) & ":"& RIGHT("0" & Sum(Fields!Actual_Time.Value*3600) - Floor(Sum(Fields!Actual_Time.Value*3600) / 60) * 60, 2)
I need the solution early.
Thanks in advance !