A question on calculated time range

[Jalz]

Hi Guys,

Need your assistance again.

I have two time fields, start_time and end_time.

I have a container field called graphic, which contains a coloured block.

Im trying to define a field that does the following.

If (9:00 within the range start_time and end_time, display grapic, "")

Is this possible?

Any help would be much appreciated, all ym attempts have come to nothing so far.

Kindest regards

Jalz

[Lee Smith]

Are you trying to Hard code the time 9:00 (AM, PM?) into your calculation or, are trying to find out if a time of 9:00 (AM, PM ?) when entered into either the start, or end, time falls within a range such as 8:00:00 to 17:00:00?

To display a flag (colored block) will not be a problem once we understand your Parameters.

HTH

Lee

[DanBrill]

Yes, this is possible. You need a calculation field that has a container as a result. Assume you have 5 fields

StartTime

EndTime

EvalTime - the time you want to evaluate

gGraphic - a global container with the graphic you want to display

cGraphicCalc - a calc field with a container result and the calculation:

if(EvalTime>StartTime and EvalTime<EndTime,gGraphic,"")

That should do it, though I didn't test this.

Best,

Dan

[Jalz]

Thanks for your prompt reply Lee,

Yes I am hard coding 9:00:00 at the moment.

Kind regards

Jalz

[Jalz]

Thanks Dan,

Tried your suggestion, which is what I thought it should be, before I posted this question. No luck, the syntax I currently have is below:

If("9:00:00" > Start_Time and "9:00:00" < End_Time,GraphicBlock,"")

im sure there is a simple answer lurking.

Thanks again

[Lee Smith]

I think you have to use Time(09, 00, 00) instead of "9:00:00"

[Lee Smith]

Try this calculation, I think it does what you want.

Case(Time(09, 00, 00) >= start_time or Time(09, 00, 00) <= End_time, Container,"")

HTH

Lee

[DanBrill]

Yeah, if you were doing the way I did in my example the the StartTime and EndTime fields were set to tme format it would work, or if you are hard-coding, use Lee's syntax.

Cheers,

Dan

[Jalz]

Thanks Guys,

Between both of you, you've sorted out my problem.

I've decided to stick to Lee's example as it suits my solution better.

Best regards

Jalz

[Jhestler]

Hi all,

I would like to be able to enter the starting time of a video segment into one field (in hours, minutes, seconds and frames), then the end time into another (also in hours, minutes, seconds and frames), and then have the segment length field show the segment length as an accurate calculation between these two fields.

I know there is a plug-in that allows you to capture direct from video, but i don't need to capture video for this thing I'm trying to do. I just can't seem to get my heard around it.

One additioanl issue that may come into play is that this has to work for NTSC, PAL, and SECAM frame rates, some of which include decimal figures to the tenths (ex. 29.97). I imagine this can be accommodated with an additional case field to identify which frame rate the calc will be dealing with, or perhaps the addition of another field to describe 10ths of a frame.

Any suggestions from you video heads out there?

Warm regards and thanks...

[Lee Smith]

Would the time displayed such as 01:30:33 suffice for all three formats?