datediff minutes and hours (1 Viewer)

[Cereldine]

I would like to calculate the time difference between two dates, what ive got so far is

TimeSpent: DateDiff("n",[datein],[dateout])

This calculates the minutes between two dates, Can you format this so that it calculates hours. minutes for example 124 minutes would be 2.04?

I thought using "h/n" might work but it hasnt
thanks

 

[Jon K]

TimeSpent: DateDiff("n",DateIn,DateOut)\60 & "." & Format(DateDiff("n",[datein],[dateout]) Mod 60,"00")
.