Results 1 to 7 of 7
  1. #1
    Join Date
    May 2014
    Posts
    3

    Unanswered: Datediff with custom format

    Hi All,

    Is it possible to use the datediff function with a custom format? I use the function to calculate two times. But the function calculating like 60 minutes.

    I want that 100 is a whole hour. 0.25 is 15 minutes. 0.50 is 30 minutes etc.
    Like this:

    Startdate Enddate Calculate
    11:00 - 11.30 - 0.50
    12:15 - 12:30 - 0.25

    I hope someone can help me.
    Thanks in advance.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Use DateDiff() to calculate minutes, and divide the result by 60.
    Paul

  3. #3
    Join Date
    May 2014
    Posts
    3
    Can you give me an example please?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    May 2014
    Posts
    3
    Ofcourse i've already searched for that, but i cannot find an example for what i want.

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Where's the problem? Do you know how to use DateDiff() to calculate minutes? Do you know how to divide a number by 60?
    Have a nice day!

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    OK so if you have already searched for that, then what have you tried
    based on your current trial what is going wrong, and why do you think it is going wrong
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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