Totals for time fields

[mamaw]

I have a database that has start and end times in it. In order to find the amount of time spend, I created a calculated field in my query. I used the following formula:

Format([StartTime]-1 -[EndTime], "Short Time")

My query works great, but when I attempt to run my report I get an error:

The Microsoft Jet database engine could not execute the SQL statement because it contains a field that has an invaldi data type.

I know that I am getting this message because my Total Hours field has been changed by the above format. I need to total these hours.

HELP!
Mamaw

 

[ddmcn]

separation

Mamaw,

Can you separate the transaction into to parts...do the calculation then use your form or report to format the result as 'Short Time'?

 

[mamaw]

Thanks. Sometimes you are too close to the problem to see the light.