DateDiff Function for Time

[Kindi]

I have 2 text boxes, starttime and endtime, when the user enters in start and end times, another third box populates with the total time take between the start and end times, the control source of the total time is set to this:

=DateDiff("h",[startTime],[EndTime])

All of this works ok, but i want the time difference to be in minutes not hours.

How do i do this?

Thanks

 

[danvlas]

Change "h" to "n".

Regards,

Dan

 

[gol4]

Kindi,

In thread702-334282 you asked how to get both hours and minutes. I posted the getelapsedtime function that should produce what you were wanting. Did that not work for you?

 

[Kindi]

Hi gol4

Thanks yes it did work for me, just that by using the "h" i got difference in hours and i needed minutes.

Everything works as it should now.

Many thanks