+ Reply to Thread
Results 1 to 2 of 2

Calculating Hours between Dates and Times VBA

  1. #1
    Registered User
    Join Date
    04-17-2011
    Location
    Orlando
    MS-Off Ver
    Excel 2007
    Posts
    27

    Exclamation Calculating Hours between Dates and Times VBA

    Problem,

    I am trying to create an application that records work time. So a user would record his start work time, and after the completion of the job, Record the End work time. I am having problems with the code that determines that hours needed for the job.

    So in the sample below, the code determines the last imput Start date and Start Time, and then Deduts that from the current Date and time.
    However I cant get the hours to come out right. If the project is too long, the code doesn't work right?

    help??


    Please Login or Register  to view this content.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Calculating Hours between Dates and Times VBA

    Hi Crebsington
    Dont really follow what your doing but
    have a look at this example form the VBA help on DateDiff

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1