Hi,
I have a databand with some information. one of them is time (HH:MM). and I would like to have the total of the time from this table.
I have been using {cSum(DataBandx,Hour(xxxxx))} and this way I have only the total of the hours, not included the minutes.
Does anyone know how to solve it?
Thank you.
SUM - from time inside a tab
-
- Posts: 30
- Joined: Mon Jan 29, 2018 11:04 am
Re: SUM - from time inside a tab
Hi John,
If you would like to get a sum of total minutes, then it is possible to do like that:
Thank you,
Edward
If you would like to get a sum of total minutes, then it is possible to do like that:
Code: Select all
{cSum(DataBandz,60*int.Parse(xxxxx.ToString("hh"))+int.Parse(xxxxx.ToString("mm")))}
Edward
-
- Posts: 30
- Joined: Mon Jan 29, 2018 11:04 am
Re: SUM - from time inside a tab
Hi Edward,
thank you, but we are almost there. the idea is not to have the sum in minutes, but in hours and minutes, for example: if I have a table with two values: 10:20 and other 09: 25, the total would be: 19:45, this would be the expecting result.
do you have other hint?
tks.
thank you, but we are almost there. the idea is not to have the sum in minutes, but in hours and minutes, for example: if I have a table with two values: 10:20 and other 09: 25, the total would be: 19:45, this would be the expecting result.
do you have other hint?
tks.
Re: SUM - from time inside a tab
Hi John,
No problem, please check the following approach:
Thank you,
Edward
No problem, please check the following approach:
Code: Select all
{Totals.cSum(DataBandx,int.Parse(xxx.ToString("hh")))} : {Totals.cSum(DataBandx,int.Parse(xxx.ToString("mm")))}
Edward