How to get correct timeout

[#1]

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

[tresesco · Accepted solution]

Try like:

Time(Avg(Frac(TimeOut)),'hh:mm tt')

[#3]

still same answer(11:55 pm) i am getting

[tresesco]

I am getting 4:10 P.M.

PFA