Time calculation problem

[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

 

[Michael Bauer [MVP - Outlook]]

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

 

[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:1

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

 

[Michael Bauer [MVP - Outlook]]

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