This content has been marked as final. Show 3 replies
1 of 1 people found this helpful
Divide by 1440 and custom format hh:mm:ss
Thanks, it works.
- Create a calculated field with function = [column_name] /1440
- right click the calculated field and follow Change Datatype>DateTime
- put the new field in a visual, and right click the element (i.e. in columns or rows pane), then select Format:>Scale>Dates>Custom,>then type hh:mm
Thanks for Deepak Rai