How would this affect the below AQ10 formula?

Yes, think there'll be impact on the criteria (eg: is time entered as time
format: 3:30, or as a number: 3.5, etc.)

Think it's much easier to take a look at what you really have over there.
Could you upload a "sanitized" small sample copy of your file via a free
filehost* and then post the *link* to it in response here (the link will be
generated when you "upload" in the filehost (follow the instructions there),
then just copy the link and paste it into your reply to this post)

*Some free filehosts that could be used:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php

For cjoint.com (it's in French), just click "Browse" button,
navigate to your folder select the sample file Open, then click the
button centred in the page below (labelled "Creer le lien Cjoint") and it'll
generate the link. Then copy & paste the generated link as part and parcel
of your response here.

Kindly note that no attachments
should be posted *directly* to the newsgroup

Posting a link to your sample here (instead of going off-line) will enable
the discussions to be continued within the newsgroup, visible to and for the
benefit of all readers. And there could well be better insights coming from
others, too <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kane" wrote in message
...
Max... I have not tried this yet,but a question re. Condition1. The time I
indicated (5.0) could be any number of hours & minutes, depending upon the
input start (B10) and stop (C10) time. How would this affect the below
AQ10
formula?

...Kane