Display datediff results as Days Hrs and Mins 1

[vangundy]

I am trying to use the datediff fucntion to obtain the diff between two dates and to display it as Days Hrs and Minutes

The results show as:
4 97 5775

When it should show as:
4 0 15

Here is my data being used in my Access query:
Date1 = 2005/06/27 19:45:00
Date2 = 2005/07/01 20:00:00

Days: DateDiff("d",[date1],[date2])
Hours: DateDiff("h",[date1],[date2])
Minutes: DateDiff("n",[date1],[date2])

Expr Duration: [Days] & " " & [Hours] & " " & [Minutes]

 

[PHV]

Duration: Int(DateDiff("d",[date1],[date2])/1440) & " " & Format(DateDiff("d",[date1],[date2])/1440,"h n")


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vangundy]

the result using your expression is:
0 0 4

Where is the 15 minutes? Should be:
4 0 15

 

[PHV]

OOps, sorry for the typo:
Duration: Int(DateDiff("[highlight]n[/highlight]",[date1],[date2])/1440) & " " & Format(DateDiff("[highlight]n[/highlight]",[date1],[date2])/1440,"h n")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[vangundy]

Perfect thanks... RESOLVED