Column Formats

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

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
>

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
> >

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
> > >

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
> > > >

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
> > > > >

Thanks Eric
That worked great. Although I would've liked to be able to enter the value
in hours or minutes and automatically display it in hours instead of adding
an extra formula field.
Thanks for your help:-)



"Eric Legault [MVP - Outlook]" wrote:

> 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
> > > > > >