[rt-users] time worked etc display in hours by default?

Kenneth Crocker kenn.crocker at gmail.com
Wed Oct 17 22:10:50 EDT 2012


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

On Wed, Oct 17, 2012 at 3:21 AM, Alex Young <AlexYoung at 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 at lists.bestpractical.com [mailto:
> rt-users-bounces at lists.bestpractical.com] *On Behalf Of *Alex Young
> *Sent:* 16 October 2012 16:49
> *To:* rt-users at 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! http://bestpractical.com/jobs
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20121017/f77355ec/attachment.htm>


More information about the rt-users mailing list