time function - minutes interval

[ilanbaruch]

hi I want to measure game session time in minutes ,

in my script i tried the following :

1. EndTime - StartTime as GameDuration,
2.   Interval( EndTime - StartTime,'HH:MM')as GameDurationF,
3.   Num(Second(EndTime)) - Num(Second(StartTime)) as GameDurationN,
4.  //interval( EndTime - StartTime, 'hh:mm')as GameDuration,

in the layout I tried:

1. =Interval( EndTime - StartTime,'HH:MM:SS')

none of them brings back a true value of minutes

any ideas ???

[alexandros17]

Try with

Date(EndDate - StartDate, 'hh:mm:ss')

[PrashantSangle]

Hi,

If both are in date format then Interval() must work for you.

try with date#() and timestamp#()

try like

interval(timestamp#(EndTime,'DD/MM/YYYY hh:mm:ss') - timestamp#(StartTime,'DD/MM/YYYY hh:mm:ss'),'D hh:mm')

Regards

[ilanbaruch · Accepted solution]

thank you!

[ilanbaruch]

hi,

now I have a GameDuration field in the script.

in my layout I want to present avg (GameDuration ) in a bar chart but result comes not true.

thank you for your help