|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
July 25th 08, 10:14 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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. 
|
| Ads |
|
#2
July 29th 08, 09:01 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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.
|
|
#3
July 30th 08, 12:57 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Field formula in custom form | Mike5116 | Outlook - Using Forms | 2 | December 8th 07 04:05 PM |
| Problem with advanced search on custom field w/ formula | Bodo | Outlook and VBA | 3 | June 27th 07 05:39 PM |
| Adding formula field to custom task form | SHC | Outlook - Using Forms | 1 | March 25th 07 10:12 PM |
| Outlook 2003 Forms - Inserting a space in a field formula | DBH | Outlook - Using Forms | 2 | January 25th 06 05:03 AM |
| New Field Formula editor | Sue Mosher [MVP-Outlook] | Outlook - Using Contacts | 0 | January 18th 06 06:10 PM |
Linear Mode
