I have a column of time totals in a table that I'd like to add.
and so on. The method is to split/parse the string, add the rightmost 2 digits of each total to get the total minutes, and the leftmost 2 digits to get the total hours. I haven't included anything to process the minutes total further (i.e. mins / 60 etc) as I can't even get the basic calculation working first.
The code I'm trying is:
//check if at least one row exists in this section of the table
//add rightmost two digits to get minutes total
//add leftmost two digits to get hours total
hrs = Sum (Left (Row1[*].total[*], (Len (Row1[*].total[*] - 3))))
Message was edited by: HarryOhm