Time formula

[wgechter]

I have a few formulas.

@time
numbervar hourplace:= {MRSC99.T_CHART_OPEN}/60;
numbervar seconds:= remainder({MRSC99.T_CHART_OPEN},60);
numbervar hours:= round((hourplace/60));
numbervar minutes:= round(remainder(hourplace,60));
time(hours,minutes,seconds)

@minute
numbervar testhour:= {MRSC99.T_CHART_OPEN}\60;
remainder(testhour,60)

@hour
numbervar testhour:= {MRSC99.T_CHART_OPEN}\60;
round(testhour/60)

@second
remainder({MRSC99.T_CHART_OPEN},60)

The bottom three are to test the top one (@time). It seems that my minutes are not matching. The @time one will display 9:51:49 and the @minute will have 50. Everything else matches but the minutes and it is only a minute off always less then one the full time displays. I have the round function on the @time formula because it doesn't work without it but the @minute formula works without it. This may lie my problem but I don't know how to correct it. Thanks for the help,
Wendi

 

[synapsevampire]

The first thing you should do is post an example of what's in {MRSC99.T_CHART_OPEN}.

If it's stored as seconds use:

faq767-3543

-k

 

[wgechter]

It's a long int

 

[synapsevampire]

That doesn't help, you need to post an example...

By example you think we need to know it's data type?

Show an example of what is in there and what time it should equate to.

-k