By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

Summing up time worked

P: n/a
oyk
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 (txtTotalTimeWorked) with the formula =Sum(txtTimeWorked)
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
Oct 26 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.