Hours/Days

[FilS2BotS]

((cnt_minutes / cnt_days_played) / 60) work and the thing is it give me results like 2.196996 (number of hours) and i would like a format like 2:14 (its hours and minutes)...

[kraada]

Ah I see. You'll need to use variables then.

Create var_minutes_per_days_played_minutes and var_minutes_per_days_played_hours with definitions:

var_minutes_per_days_played_hours:
((cnt_minutes / cnt_days_played) / 60) - mod((cnt_minutes / cnt_days_played) / 60), 60)

var_minutes_per_days_played_minutes:
mod((cnt_minutes / cnt_days_played) / 60), 60)

Then use this format expression:

format( '{1}:{2}',
format_number(var_minutes_per_days_played_hours, 0, false, false),
format_number(var_minutes_per_days_played_minutes, 0, false, false))

[FilS2BotS]

The format expression is not valid and i can not find the way to fix it... ? :?

[kraada]

In the variables or in the stat? The stat's expression is valid - I just tested it. Are you certain you named the variables properly?

[FilS2BotS]

The Value Expression still : ((cnt_minutes / cnt_days_played) / 60) ???
It write me 0:0

[WhiteRider]

The stat's value expression should just be:
cnt_minutes / cnt_days_played

Use the Format Expression to display the hours and minutes separately and formatted.

[FilS2BotS]

I have those 2 variables:

var_minutes_per_days_played_hours:
((cnt_minutes / cnt_days_played) / 60) - mod((cnt_minutes / cnt_days_played) / 60), 60)

var_minutes_per_days_played_minutes:
mod((cnt_minutes / cnt_days_played) / 60), 60)



The statistic with the value expression:
cnt_minutes / cnt_days_played

And the format expression:
format( '{1}:{2}',
format_number(var_minutes_per_days_played_hours, 0, false, false),
format_number(var_minutes_per_days_played_minutes, 0, false, false))



It still give me 0:0

???

[WhiteRider]

I'd forget the variables - use this Format Expression:

format( '{1}:{2}{3}',
format_number( if ( (cnt_minutes / cnt_days_played) < 60, 0, (cnt_minutes / cnt_days_played - 30) / 60 ), 0, false, false),
if ( (cnt_minutes / cnt_days_played) MOD 60 < 10, '0', ''),
format_number((cnt_minutes / cnt_days_played) MOD 60, 0, false, false) )

..and this Value Expression:

(cnt_minutes / 60) / cnt_days_played

[FilS2BotS]

TY i added the statistic to the Repository

[WhiteRider]

Cool!