# Thread: Datediff with custom format

1. Registered User
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.

2. Registered User
Join Date
May 2005
Location
Posts
2,888
Use DateDiff() to calculate minutes, and divide the result by 60.

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

Join Date
Nov 2004
Location
out on a limb
Posts
13,692

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

6. Moderator
Join Date
Mar 2009
Posts
5,442
Where's the problem? Do you know how to use DateDiff() to calculate minutes? Do you know how to divide a number by 60?

Join Date
Nov 2004
Location
out on a limb
Posts
13,692