Search results

Bob, Can you tell me what the ByVal syntax does? And I have removed the # symbols, but I don't understand what's is happening. When I've tried to use the formula =DtDiff([PR.Start Time],[PR.End Time],"dhns") or even =DtDiff ( [PR]![Start Time] , [PR]![End Time] , "dhns") I continually...

Thank you, but I have little to NO experience programming in VBA. So sadly, I've copied and pasted the code you've given me, which I understand, but can't seem to undestand how to use as a control source, my ultimate goal. I've used your function and tried to use a control source displayed as...

I had the syntax wrong, [PR.End] vs. the exclamation point. It works for days, but how can I do it so it will give me the total elapsed time?

I wish it did, but perhaps I still don't understand the syntax. The formula I'm trying to use in the Control Source for a form is =DateDiff("d",[PR]![End Time],[PR]![Start Time]) BUT DateDiff takes in the following syntax DateDiff («interval», «date1», «date2», «firstweekday», «firstweek»)...

I have a table with a star time and end time with values entered in like this Start Time EndTime 10/23/2008 6:15:51 PM 3/25/2009 9:27:40 AM They are of date/time type and a general date format string. If I try to use DateDiff(endtime-start time) I get an #Name error...