|
| 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
October 30th 09, 04:15 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Time calculation problem
One field with time is being deducted from another field with time:
I have 3 fields in a custom form: Start1 End2 Difference Difference field has a formula: [End2] -[Start1] Problem: As long as time in field End2 and Start1 are not 12:00-12:59 am or pm formula work fine so 2pm-12pm = 2 hours If I have 12:59 pm - 12:00 pm outcome is 12:59? Please help 
|
|
#2
November 3rd 09, 08:19 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Time calculation problem
See if the DateDiff function is available in a formular field, for instance: = DateDiff("h", [end2], [start1]) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 30 Oct 2009 12:15:48 -0400 schrieb bear: One field with time is being deducted from another field with time: I have 3 fields in a custom form: Start1 End2 Difference Difference field has a formula: [End2] -[Start1] Problem: As long as time in field End2 and Start1 are not 12:00-12:59 am or pm formula work fine so 2pm-12pm = 2 hours If I have 12:59 pm - 12:00 pm outcome is 12:59? Please help . Submitted using http://www.outlookforums.com
|
|
#3
December 17th 09, 11:14 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Time calculation problem
Hello
Tried DateDiff("h", [end2], [start1]). Did not work, it is constantly shows 5:00 regardless of what is in end2 and start1? Please help mb wrote on Tue, 03 November 2009 15:19 See if the DateDiff function is available in a formular field, for instance: = DateDiff("h", [end2], [start1]) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 30 Oct 2009 12:15:48 -0400 schrieb bear: One field with time is being deducted from another field with time: I have 3 fields in a custom form: Start1 End2 Difference Difference field has a formula: [End2] -[Start1] Problem: As long as time in field End2 and Start1 are not 12:00-12:59 am or pm formula work fine so 2pm-12pm = 2 hours If I have 12:59 pm - 12:00 pm outcome is 12:59? Please help . Submitted using http://www.outlookforums.com
|
|
#4
December 18th 09, 07:49 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Time calculation problem
With Debug.Print you can print the values of end2 and start1 (ctrl+g). I doubt they really change. -- Best regards Michael Bauer - MVP Outlook Manage and share your categories: http://www.vboffice.net/product.html?pub=6&lang=en Am Thu, 17 Dec 2009 18:14:09 -0500 schrieb bear: Hello Tried DateDiff("h", [end2], [start1]). Did not work, it is constantly shows 5:00 regardless of what is in end2 and start1? Please help mb wrote on Tue, 03 November 2009 15:19 See if the DateDiff function is available in a formular field, for instance: = DateDiff("h", [end2], [start1]) -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 30 Oct 2009 12:15:48 -0400 schrieb bear: One field with time is being deducted from another field with time: I have 3 fields in a custom form: Start1 End2 Difference Difference field has a formula: [End2] -[Start1] Problem: As long as time in field End2 and Start1 are not 12:00-12:59 am or pm formula work fine so 2pm-12pm = 2 hours If I have 12:59 pm - 12:00 pm outcome is 12:59? Please help . Submitted using http://www.outlookforums.com . Submitted using http://www.outlookforums.com
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Time problem | JBO | Outlook - General Queries | 1 | May 21st 09 12:51 PM |
| DateDiff Calculation | Henry Stockbridge | Outlook and VBA | 4 | August 15th 08 12:19 AM |
| Time Problem | Paul W Smith | Outlook - General Queries | 6 | April 23rd 08 02:21 PM |
| Another Time Zone Problem | Matthew Schwarz | Outlook - Calandaring | 4 | January 27th 08 07:02 PM |
| File as Calculation | laura | Outlook - Using Contacts | 0 | October 4th 07 09:05 PM |
Hybrid Mode
