Hello,
I have a column of time totals in a table that I'd like to add.
For example:
11:33
25:56
67:44
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))))
endif
Message was edited by: HarryOhm
Views
Replies
Total Likes
Please disregard. I got it working finally.
Views
Replies
Total Likes
What was the final code that worked?
thanks,
Views
Replies
Total Likes