DateDiff value

[angie]

Hi I have a field called "arrived time and one called completed time"
I have a field that has the following in default value.
it works but I need it to show in the following format " hours and minutes " not just a total of minutes

if the arrived time is 3:00am and the completed time is 4:30am than I want it to give me the default value of 1 hour 30 minutes.

=DateDiff("n",[Arrived Time],[Completed Time])

Thanks

[angie]

I changed the above to

=datediff("n",[arrived time],[completed time])/60

so if the arrived time is 9:30am and the completed time is 2:10pm it returns the value of 4.666666666666666667 I need it to return the value of 4 hours 40 minutes

Thanks Angie

[ssanfu]

Here is an expression... Note that if the time crosses midnight, you will get unexpected results.

=int(datediff("n",[arrived time],[completed time])/60) & " hours " & datediff("n",[arrived time],[completed time]) Mod 60 & " minutes"

NOTE: It is not considered a good practice to have spaces in object names (especially field names).
Use only letters and numbers (exception is the underscore). Also do not use punctuation or special characters in object names.

[angie]

=DateDiff("n",[Arrived Time],[Completed Time])\60 & Format(DateDiff("n",[Arrived Time],[Completed Time]) Mod 60,"\:00")

I Figured it out and the above works great incase someone else has the same problem. Angie

[angie]

Thanks yours is better than what I came up with thanks so much (using yours)
Thanks again

[ssanfu]

Happy to help....