Hi all,
to calculate the total time for a sport event, i have to add several section times, but the result seems to be wrong. The values are stored in a table:
Example:
At 12:00 o'clock, I want to add 1:45 minute. The calculation is done with the following code :
Table1.Cell("col3",0) = Time(TimeParse(StartTime) + TimeParse(Table1.Cell("col1",0))
filled in with values this means:
total time = Time(TimeParse(12:00:00) + TimeParse(01:45:00)
and the result = 12:44:00
How could this be ?????? any idea ????
Any help would be great.: