Determining Elapsed Military Time

[opie]

I have 4 fields: StartDate, StartTime, EndDate, EndTime.
The date Format is dd-mm-yyyy and the time is military,
hh:mm
I would like to calculate the difference or the elapsed
time between StartTime and EndTime.

I found some information on determining elapsed Date/Time
but the date and time are in the same field. I did an
update query to my data into a new field, Date/Time.
The module that was given worked fine after I did the
update query.

But I was wondering if there is another way without
running an update query to get my data to conform to the
module.

 

[Duane Hookom]

You could use (EndDate + EndTime) - (StartDate + StartTime). This result
will return the percentage of a day. You can also use the DateDiff()
function or other.