Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this:
=Time(Time#(Num(Num#('1.3', '#.#'), '#.00'), 'h.mm'), 'h:mm')
Try this:
=Time(Time#(Num#('1.30', '#.##'), 'h.mm'), 'h:mm')
Replace '1.30' with yout Time Field.
thanks'
but it's still the same
It seems to be working here:
Try,
=Time(Time#('1.30', 'hh.mm'),'h:mm')
try 1.3 not 1.30
Try this:
=Time(Time#(Num(Num#('1.3', '#.#'), '#.00'), 'h.mm'), 'h:mm')
now it's look o.k. but where i need to write "sum" ?
With regards to Sum, what exactly are you doing? Not really sure
it's o.k. .
thank you very much.