View Single Post
  #2  
Old July 29th 08, 08:01 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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.

Ads