Substracting Times & Get A General Number In A Query

[Guest]

I have a Start Time column and an End Time column. I want to create a new
column that will subtract the End Time from the Start Time and give me a
general number. I've tried the following formulas but they don't seem to
work.

=Format(CDate([strDate] & " " & [strStartTime])-CDate([strDate]+1 & " " &
[strFinishTime]),"Short Time")

And

=Sum(DateDiff("n",[strDTStartTime],[strDTEndTime]))/60

The query will only run with the first formula and not the second. Any
suggestions?

 

[Allen Browne]

Drop the Sum() in the second example. The first one works because it is not
performing any aggregation.

More info in:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html