Okay, here's what you do:
Create a new custom field (either by using the New button on the Field
Chooser dialog while in the Task folder, or the New button on the All Fields
tab of your custom form) called Total Work (hours), of type Formula. Enter
this for the formula value:
Round([Total Work]/60,2) & " hours"
Now drag that field onto the form and into the view for the Task folder.
--
Try Picture Attachments Wizard for Outlook!
http://tinyurl.com/9bby8
--
Eric Legault - B.A, MCP, MCSD, Outlook MVP
Job:
http://www.imaginets.com
Blog:
http://blogs.officezealot.com/legault/
"joseph" wrote:
> Where abouts in the textbox properties do I set this? (In the Initial Value??)
> Where would I apply this formula set the column in the view to show hours
> only?
> Thanks in advance
>
>
>
> "Eric Legault [MVP - Outlook]" wrote:
>
> > Okay, I see that the formula in the Total Work field converts to hours - the
> > four available formats don't do anything for representing a fraction of an
> > hour if the value is less than one hour. You'll have to create a custom
> > field, or add a text box on the form, both with this formula:
> >
> > Round([Total Work]/60,2) & " hours"
> >
> > --
> > Eric Legault - B.A, MCP, MCSD, Outlook MVP
> > --
> > Try Picture Attachments Wizard for Outlook!
> > http://tinyurl.com/9bby8
> > --
> > Job: http://www.imaginets.com
> > Blog: http://blogs.officezealot.com/legault/
> >
> >
> > "joseph" wrote:
> >
> > > Hi
> > > Thanks for that however this hasn't resolved my question. ie Hours only.
> > > For example When entering 0.2 h in the view column, it automatically
> > > converts it to 12mins. I want it to remain showing the hours.'
> > > Can this be done?
> > >
> > > Thanks in advance
> > >
> > >
> > >
> > > "Eric Legault [MVP - Outlook]" wrote:
> > >
> > > > If you have already added a text box to your custom Task form, display the
> > > > properties dialog for that control and click the Value tab. Then choose one
> > > > of the first two values in the Format combox box - the ones that don't say
> > > > "(Work Time)".
> > > >
> > > > You can also change the display of the TotalWork column in a view by
> > > > right-clicking the column header and choose "Format Columns...", and change
> > > > the format there as well.
> > > >
> > > > --
> > > > Eric Legault - B.A, MCP, MCSD, Outlook MVP
> > > > --
> > > > Try Picture Attachments Wizard for Outlook!
> > > > http://tinyurl.com/9bby8
> > > > --
> > > > Job: http://www.imaginets.com
> > > > Blog: http://blogs.officezealot.com/legault/
> > > >
> > > >
> > > > "joseph" wrote:
> > > >
> > > > > Hi all
> > > > > I want to show total hours worked on a task in hours only.
> > > > > I'd like to show this format in both a Outlook View and a textbox in a
> > > > > custom form.
> > > > > Is this possible? If so, how?
> > > > > Thanks in advance
> > > > >
> > > > > Joseph
> > > > >
Similar Threads
