I'm having a little problem completing a graphic interface

I have a start time and end time

The graphic displays the start and end time

I have managed to display the hours ... but want to refine it to the quarter hour.

i have managed to work out a way of doing it (by hard coding the results 0 to 4 (x:00=0, x:15=2, x:30=3, x:45=4)... but can not get my calc to work. (notes in calculation)

I will further refine it by changing the calc by rounding the minutes to the quarter hour after resolving this.

I would also like to put the left and right graphic on either end of the time block ... but will tackle this afterwards

Any help would be great ... i think that i can not see the wood for the trees.

Oh and if you can see an even simpler way of achieving this im all ears.

File Attached

best

Stuart

TimeBlock.fp7.zip

Edited February 28, 200718 yr by Guest

Something like this?

Let ( [

s = Round ( Extend ( Start_Time ) / 900 ; 0 ) ;

e = Round ( Extend ( End_Time ) / 900 ; 0 ) ;

i = Get ( CalculationRepetitionNumber ) - 1

] ;

GetRepetition ( Graphics ; 1 + ( i ≥ s ) + ( i ≥ e ) )

)

Edited February 28, 200718 yr by Guest

Hi Comment,

This is really, really good.

I will modify it a little for my purposes.

I have not really dealt with time very often and had never considered handling dates as numerical values.

This is really going to make my life alot easier.

Thanks again,

Stuart

:thankyou:

I couldn't test this, but I noticed a small 'bug' - hopefully fixed now.