Time worked etc display in hours by default?

RT Users
1

Is it possible to set all times to display in hours, rather than
minutes? We have some tickets with thousands of minutes each, and it
would be much more useful to see search results as hours. Any idea if
it’s possible in RT 4.0.5?

A search hasn’t turned up anything useful.

Thanks.

2

Seems displaying the Time Worked field and Time Estimated field on the
search results always displays it in minutes in 4.0.5. Does anyone else
see this behaviour or is it something wrong with our local RT install?

Time Left works correctly, showing hours/weeks etc.

Also, is it possible to just display in hours, rather than weeks? As a
week to us is 5 days, 9am-5pm the weeks aren’t really relevant.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Alex
Young
Sent: 16 October 2012 16:49
To: rt-users@lists.bestpractical.com
Subject: [rt-users] time worked etc display in hours by default?

Is it possible to set all times to display in hours, rather than
minutes? We have some tickets with thousands of minutes each, and it
would be much more useful to see search results as hours. Any idea if
it’s possible in RT 4.0.5?

A search hasn’t turned up anything useful.

Thanks.

3

Alex,

I had a customer that wanted all time recorded in man days. An entry of 1
would = 1 day (8 hours) and an entry of 1.5 would = 12 hours or 1.5 days.
To get this to happen for all search results and displays, I had to change
the Database to define all the time fields to have 3 decimal postions to
the right of the whole number (i.e. 999.999) where 1.125 would be the same
as 1 day and 1 hour or 9 hours. Then, I changed all the html to remove the
drop-down for hours, etc. and replace it with a literal of “TIme is in
days, where .125 = 1 hour”. So the users would know that their entries were
for days with decimal positions for hours. That display had to be changed
in all entry and update displays for the time fields.

I’m not sure if you want to go to that extent. It is my understanding that
RT has a drop-down for entry, but all time is stored in minutes, which was
why I had to modify the Database.

Hope this helps.

KennOn Wed, Oct 17, 2012 at 3:21 AM, Alex Young <AlexYoung@housingpartners.co.uk wrote:

Seems displaying the Time Worked field and Time Estimated field on the
search results always displays it in minutes in 4.0.5. Does anyone else see
this behaviour or is it something wrong with our local RT install?****

Time Left works correctly, showing hours/weeks etc.****

Also, is it possible to just display in hours, rather than weeks? As a
week to us is 5 days, 9am-5pm the weeks aren’t really relevant. ****

From: rt-users-bounces@lists.bestpractical.com [mailto:
rt-users-bounces@lists.bestpractical.com] On Behalf Of Alex Young
Sent: 16 October 2012 16:49
To: rt-users@lists.bestpractical.com
Subject: [rt-users] time worked etc display in hours by default?**

Is it possible to set all times to display in hours, rather than minutes?
We have some tickets with thousands of minutes each, and it would be much
more useful to see search results as hours. Any idea if it’s possible in RT
4.0.5?****

A search hasn’t turned up anything useful.****

Thanks.****

Final RT training for 2012 in Atlanta, GA - October 23 & 24
http://bestpractical.com/training

We’re hiring! Careers — Best Practical Solutions

4

Thanks Ken,

            Did you also find that only the one field ever shows in

days/weeks, and all the other time fields show in minutes on the search
results page too?

Might just look at changing the search results page to display in hours,
but the above problem would still be a concern.

Thanks,

AlexFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: 18 October 2012 03:11
To: RT User List
Subject: Re: [rt-users] time worked etc display in hours by default?

Alex,

I had a customer that wanted all time recorded in man days. An entry of
1 would = 1 day (8 hours) and an entry of 1.5 would = 12 hours or 1.5
days. To get this to happen for all search results and displays, I had
to change the Database to define all the time fields to have 3 decimal
postions to the right of the whole number (i.e. 999.999) where 1.125
would be the same as 1 day and 1 hour or 9 hours. Then, I changed all
the html to remove the drop-down for hours, etc. and replace it with a
literal of “TIme is in days, where .125 = 1 hour”. So the users would
know that their entries were for days with decimal positions for hours.
That display had to be changed in all entry and update displays for the
time fields.

I’m not sure if you want to go to that extent. It is my understanding
that RT has a drop-down for entry, but all time is stored in minutes,
which was why I had to modify the Database.

Hope this helps.

Kenn