Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    178

    Unanswered: Working out Time difference.

    Hi,

    What would be the best way of working out time difference, including different days.

    i.e

    Start time 15/12/08 2300hrs to 16/12/08 0700hrs.

    Any ideas?

  2. #2
    Join Date
    May 2006
    Posts
    178
    I should have added,
    "Interms of hours"

  3. #3
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    Will the time always be in hours e.g. 0700, 1500 etc or will the time also have minutes e.g. 0730, 1545 etc.?

    If 0700 and 1500 etc. then use DateDiff("h", start_time, finish_time) this will give you the number of hours. If the time also includes minutes you will need to use DateDiff("n", start_time, finish_time)/60 this will give a result with decimal values e.g. 133.34 hrs etc.

  4. #4
    Join Date
    May 2006
    Posts
    178
    Thankyou very much poppa, ill give it ago.

Posting Permissions

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