In the detail section of a report is a textbox (txtTimeWorked) in hour and
minute format (i.e. hh nn). In the page header section, I put in a
calculated textbox (txtTotalTimeWo rked) with the formula =Sum(txtTimeWor ked)
in the same "hh nn" format.
However, the result is not correct. Example: 23.00 + 23.00 + 23.00 +13.53
gets me 13.53 when it should be 85.53. I changed the format to d hh nn and I
got 2day 13min 53sec which is also not right and should be 3day 13 min 53
sec.
Hope someone knowledgeable out there could offer some help.
Thanks a million
minute format (i.e. hh nn). In the page header section, I put in a
calculated textbox (txtTotalTimeWo rked) with the formula =Sum(txtTimeWor ked)
in the same "hh nn" format.
However, the result is not correct. Example: 23.00 + 23.00 + 23.00 +13.53
gets me 13.53 when it should be 85.53. I changed the format to d hh nn and I
got 2day 13min 53sec which is also not right and should be 3day 13 min 53
sec.
Hope someone knowledgeable out there could offer some help.
Thanks a million