how to get minutes in hour format.

[jay_patel]

Hello All

example "200" minutes I need to get in format "3:20".

thanks in advance

[amitchandak · Accepted solution]

@jay_patel , two new columns

New column =
Quotient([column],60) & ":" & mod([column],60)

or

New column =
time(Quotient([column],60) , mod([column],60) )

same calculation can be used in measure

[jay_patel]

Hi @amitchandak ,

Thanks for your reply,

It's working, but need to get in Total in matrix visual.