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.

[sunny_talwar]

Try this:

=Time(Time#(Num#('1.30', '#.##'), 'h.mm'), 'h:mm')

Replace '1.30' with yout Time Field.

[Anonymous]

thanks'

but it's still the same

[sunny_talwar]

It seems to be working here:

[tamilarasu]

Try,

=Time(Time#('1.30', 'hh.mm'),'h:mm')

[Anonymous]

try 1.3 not 1.30

[sunny_talwar · Accepted solution]

Try this:

=Time(Time#(Num(Num#('1.3', '#.#'), '#.00'), 'h.mm'), 'h:mm')

[Anonymous]

now it's look o.k. but where i need to write "sum" ?

[sunny_talwar]

With regards to Sum, what exactly are you doing? Not really sure

[Anonymous]

it's o.k. .

thank you very much.