Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
for the data i attached
in the straight table i taken
dimension:employee id
expression:=Time(Avg(TimeOut),'hh:mm tt')
but i am getting 11:55 pm as avg timeout which is wrong
how to get correct timeout value
regards
hemesh
Try like:
Time(Avg(Frac(TimeOut)),'hh:mm tt')
still same answer(11:55 pm) i am getting
I am getting 4:10 P.M.
PFA