Time format

[idiotperson]

Hi .... What can i do if i want to get the sum answer by time format instead of general number....

For example, 700 min is the time , i don't want it to show as 11.67 and want it to be 11 hours and 40 mins

[HighAley]

Hello.

You could set the Text Format to the necessary value or use ToString("hh:mm") method.
Could you specify where you have the time and what is the format of the source?

Thank you.

[idiotperson]

{Sum(GroupHeader3,MasterData.DiffMinutes)}
the format of source

[HighAley]

Hello.

Could you specify what is the type of the MasterData.DiffMinutes column?
If the column has right type, you could use next expression:

Code: Select all

{Sum(GroupHeader3,MasterData.DiffMinutes).ToString("hh:mm")}

Thank you.