Page 1 of 1
Time format
Posted: Mon Aug 17, 2015 11:52 am
by 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
Re: Time format
Posted: Mon Aug 17, 2015 12:47 pm
by 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.
Re: Time format
Posted: Tue Aug 18, 2015 2:46 pm
by idiotperson
{Sum(GroupHeader3,MasterData.DiffMinutes)}
the format of source
Re: Time format
Posted: Wed Aug 19, 2015 6:49 am
by 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.