DateDiff

Koulla · External Since: Nov 03, 2009 Posts: 2

Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I am
using datediff to find the different but it appears only in minutes !
I want to separate different on days, Hours and Minutes !

This is what I am using
=(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only minutes
appears I want difference in day, Hours and minutes something like that
2Days, 2Hours, 34Minutes

Thanks in advance
Koulla

Jerry Whittle · External Since: Mar 03, 2006 Posts: 1240

Format(CDate(DateDiff("n",[DateBreakable],[DateResponce)/1440) +1 , "d:h:m")

I bet that there's a better way, but it's all that I got.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Koulla" wrote:

> Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I am
> using datediff to find the different but it appears only in minutes !
> I want to separate different on days, Hours and Minutes !
>
> This is what I am using
> =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only minutes
> appears I want difference in day, Hours and minutes something like that
> 2Days, 2Hours, 34Minutes
>
> Thanks in advance
> Koulla

Rick Brandt · External Since: Nov 04, 2004 Posts: 28

On Tue, 03 Nov 2009 04:05:01 -0800, Koulla wrote:

> Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I
> am using datediff to find the different but it appears only in minutes !
> I want to separate different on days, Hours and Minutes !
>
> This is what I am using
> =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only
> minutes appears I want difference in day, Hours and minutes something
> like that 2Days, 2Hours, 34Minutes
>
> Thanks in advance
> Koulla

There is no built in function in Access that does that. You could of
course create a custom function in which you do the math yourself and
return a text string in that format.

One of the regulars in these groups (I want to say Albert, but that could
be wrong) has already written a function that does what you want. If you
search these groups you might be able to find a post referring to it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

John Spencer · External Since: Jul 15, 2009 Posts: 47

Try the "More Complete DateDiff Function" Graham Seach and Doug Steele wrote.

http://www.accessmvp.com/djsteele/Diff2Dates.html

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Rick Brandt wrote:
> On Tue, 03 Nov 2009 04:05:01 -0800, Koulla wrote:
>
>> Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I
>> am using datediff to find the different but it appears only in minutes !
>> I want to separate different on days, Hours and Minutes !
>>
>> This is what I am using
>> =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only
>> minutes appears I want difference in day, Hours and minutes something
>> like that 2Days, 2Hours, 34Minutes
>>
>> Thanks in advance
>> Koulla
>
> There is no built in function in Access that does that. You could of
> course create a custom function in which you do the math yourself and
> return a text string in that format.
>
> One of the regulars in these groups (I want to say Albert, but that could
> be wrong) has already written a function that does what you want. If you
> search these groups you might be able to find a post referring to it.
>
>
>

Koulla · External Since: Nov 03, 2009 Posts: 2

Thank you Jerry it works perfectly
Thank you so much !!!

"Jerry Whittle" wrote:

> Format(CDate(DateDiff("n",[DateBreakable],[DateResponce)/1440) +1 , "d:h:m")
>
> I bet that there's a better way, but it's all that I got.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Koulla" wrote:
>
> > Hi I am using date time field in this format 8/10/2009 10:00:00 pm and I am
> > using datediff to find the different but it appears only in minutes !
> > I want to separate different on days, Hours and Minutes !
> >
> > This is what I am using
> > =(DateDiff("n",[DateBreakable],[DateResponce])) it works ok but only minutes
> > appears I want difference in day, Hours and minutes something like that
> > 2Days, 2Hours, 34Minutes
> >
> > Thanks in advance
> > Koulla