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:

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