time format

[Anonymous]

hi,

i have feild like this 1.30 , 1.28  - that represents time.

i'm using that function  -- Time(Sum(time#((Cat00), 'hh.mm')),'hh.mm') to calculte time.

the nimber at the pivot proporties is interval.

when the number is 1.30 which means 1 hour & 30 minute i get 1.03 = 1 hour & 3 minute.

when the number is 1.28 i get yhe right number 1 hour & 28 minute.

what is wrong ?

thanks'

yarin.

[jagan]

Hi,

Try like this

Time:

LOAD

Time(Time#(Num(Num#(TimeStamp, '#.#'), '#.00'), 'h.mm'), 'h:mm') AS TimeStamp,

(Subfield(TimeStamp) * 60) + (Subfield(TimeStamp, 2)) AS Minutes

INLINE [

TimeStamp

1.3

2.3

2.0];

Now in charts or text object use

=Div(Sum(Minutes), 60) & ':' & Mod(Sum(Minutes), 60)

Hope this helps you.

Regards,

Jagan.