I am working on a database that captures elapsed time for activities in my shop.

I have three fields: START -- STOP -- ELAPSED TIME.

The START field automatically enters the creation time when a new record is born.

The STOP time is generated with a script that inserts current time into the stop field.

ELAPSED TIME is a calculated field: (Stop-Start)/60.

Everything works just fine until I cross the midnight hour.

At this point values which should be positive end up being negative.

For example: If you start working at 11 PM and work until 2 AM you should record 180 minutes. The result I am getting is minus (-) 1260 minutes.

I know this problem has already been solved a hundred times, but not by me. Can somebody help aim me here?

Thanks,

Jarvis

You need to include the StartDate and EndDate into the calculation...

ElapsedTime = ((EndDate - StartDate) * 3600 + (EndTime - StartTime)) / 60

Vaughan,

Thank you for the succinct response. It did the trick!

Jarvis