MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Calculating duration

  Asked By: Gerritt    Date: Dec 02    Category: MS Office    Views: 1682

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.



1 Answer Found

Answer #1    Answered By: Venkat Rulez     Answered On: Dec 02

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.