how to calculate time intervial in access

[pH]

if i want to calculate the working hr from 9:00am to
6:00pm in a column

 

[Allen Browne]

See:
Calculating elapsed time
at:
http://members.iinet.net.au/~allenbrowne/casu-13.html

It explains how to use DateDiff() to get the difference in minutes, and
format the result as hours and minutes.