Search results for query: *

Then we would just change the startdate/time. It's not a 'set in stone' kind of date. It's just used to track mainly when a issue started - which is very possible that it could be entered incorrectly the first time. I'm just trying to go one step further and give them an auto calculated duration...

SkipVought and Melagan - Thanks for the info. I had not thought about using the date values. PHV - I didn't elaborate at all - I need a seperate time field because the time more than likely will not be the same time the record is entered. It's a problem ticket kind of record. For instance the...

Thanks Crowley - i just didn't know how to enter the syntax for datediff with both day and time fields. After a little playing I put in as: dim tstart, tend as string tstart = starttate & " " & starttime tend = endtate & " " & endtime dur = DateDiff("h", tstart, tend) Thanks!

Hello, is there a way in VBA to calculate the the time span, in hours, between two dates with both a day and time? For instance I have four fields (with data): startdate (01/01/07) starttime (09:00:00 am) enddate (01/03/07) endtime (2:00:00 pm) duration = 54:00 (hours/minutes) What would be a...