Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I wish to do the following but can't seem to work it out.

I have a form with 2 text boxes txtStart,txtFinish and txtDuration. I

would like a user to be able to click cmdCal and the no. of hours and

minutes between the 2 times to be displayed in txtDuration. I need to

make sure no negative values are returned. ie if start time is 2300hrs

and finish time is 0900hrs it shows 14 hours not -14. Im sure this can

be all written in vba.

Show us what you have so far, and we will take it from there.

Didn't find what you were looking for?
Find more on Calculating duration
Or get search suggestion and latest updates.

Related Topics:

- Calculating Ratios
- Convert string like "=123+456+789" to Long and then calculate
- Calculate fields (Pivot Tables)
- 2003 - ActiveSheet.Calculate Problem
- Calculating values in VB
- Calculating Time in parts of an hour
- To calculate the time difference between two days
- calculating 'names' of text boxes in a form
- Application.Calculate fails
- Convert string like "=123+456+789" to Long and then calculate
- Calculating the no. of containers
- Easier method to capture & paste calculated value?
- Excel won't calculate my function
- write a program that enters double data into an ArrayList and calculate the total
- How to calculate IRR
- Calculate Total Sum
- calculate exeuction time
- calculate area
- Calculate pH of Rainwater
- calculate age
- calculating area of a regular polygon
- calculate Mean
- Calculate salary. can any one give the asnwer ??