Thread: How do I edit a formula field in outlook to round up
View Single Post
  #3  
Old July 30th 08, 11:57 AM posted to microsoft.public.outlook.program_vba
hazard hanson[_2_]
external usenet poster
  
Posts: 3
Default 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.
Ads