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

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

 

[Michael Bauer [MVP - Outlook]]

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:

 

[hazard hanson]

Thanks Michael, you are excellent!!

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: