How do I edit a formula field in outlook to round up
 

I have added start and finish time field in outlook tasks and want to use a
formula to total the hrs worked against the task. This all works OK except
that the total hrs are not rounded up to two decimal places. Any idea how I
can format the formula field for a new field to do this.

Thanks in advance to anyone who can help.

How do I edit a formula field in outlook to round up
 

Try

Format(Expression, "#,##0.00")

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Fri, 25 Jul 2008 13:14:00 -0700 schrieb hazard hanson:

I have added start and finish time field in outlook tasks and want to use
a
formula to total the hrs worked against the task. This all works OK except
that the total hrs are not rounded up to two decimal places. Any idea how
I
can format the formula field for a new field to do this.

Thanks in advance to anyone who can help.

How do I edit a formula field in outlook to round up
 

Thanks Michael, you are excellent!!

"Michael Bauer [MVP - Outlook]" wrote:



Try

Format(Expression, "#,##0.00")

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Fri, 25 Jul 2008 13:14:00 -0700 schrieb hazard hanson:

I have added start and finish time field in outlook tasks and want to use
a
formula to total the hrs worked against the task. This all works OK except
that the total hrs are not rounded up to two decimal places. Any idea how
I
can format the formula field for a new field to do this.

Thanks in advance to anyone who can help.