A
Ant
I am having a bit of trouble with the Datediff function. I have two fields
Start_Time and End_Time I want to use the DateDiff command to calculate the
difference between the two times ( answer to be in hours and mins ) although
DateDiff(“h”,[Start_Time],[End_Time]) gives me the number of hours and
DateDiff(“n”,[Start_Time],[End_Time]) gives me minuets how can I get the
correct hours and mins together in ideally one text box but two would be OK.
E.g. Start Time = 9:00 AM
End Time = 11:15 AM
Answer = 2h 15min
All I can get is ether 2h or 135min
Thanks for any help
Start_Time and End_Time I want to use the DateDiff command to calculate the
difference between the two times ( answer to be in hours and mins ) although
DateDiff(“h”,[Start_Time],[End_Time]) gives me the number of hours and
DateDiff(“n”,[Start_Time],[End_Time]) gives me minuets how can I get the
correct hours and mins together in ideally one text box but two would be OK.
E.g. Start Time = 9:00 AM
End Time = 11:15 AM
Answer = 2h 15min
All I can get is ether 2h or 135min
Thanks for any help