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
=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