VBA DateDiff in hours and miutes

[hellojosie]

Hi,



New to access and vba.

I would like to calculate the difference in time and return the value to a field in hours and minutes. I have been on this for hours.

At the moment I'm back to the basics.

I have

[TimesheetTotal] = DateDiff("n", [TimesheetStartTime],[TimesheetFinishTime])

So this shows the time in minutes. But I really want to show the time in hours and minuets.

Thank you in advance for any help

[hellojosie]

oooh and if I could do this over a 24 hour clock that would be super!

I just got it to return hour and minutes using this formula:

[TimesheetTotal] = DateDiff("n", [TimesheetStartTime], [TimesheetFinishTime]) \ 60 & "." & Format(DateDiff("n", [TimesheetStartTime], [TimesheetFinishTime]) Mod 60, "00")

I would really love to be able to calulate this even if it goes into the next 24 hour period.

Thanks for any help!!!