Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Problems with time calculations & DateDiff - Please Help!

Discussion in 'Information Technology' started by Gina Whipp, Jul 28, 2006.

  1. Gina Whipp

    Gina Whipp
    Expand Collapse
    Guest

    Hey All,

    Also, I need to convert my time caculation to decimal. The below code
    actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM; then
    my Me.txtTimeDecimal = -15.00. If someone can explain why my txtTimeDecimal
    isn't working when the time crosses the day it would really help.

    If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    "tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] & "'")
    = "Active" Then
    Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime *
    24) - 24 - DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    * 24
    Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    Else
    Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime *
    24) - 24
    Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    End If

    I thought about using DateDiff but...

    ?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    carzy.


    Thanks in advanceGina Whipp
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012
    Problems with Sikh Historiography-prof Jagdish Singh Sikh Video Aug 31, 2012

  3. Marshall Barton

    Marshall Barton
    Expand Collapse
    Guest

    Gina Whipp wrote:
    >Also, I need to convert my time caculation to decimal. The below code
    >actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM; then
    >my Me.txtTimeDecimal = -15.00. If someone can explain why my txtTimeDecimal
    >isn't working when the time crosses the day it would really help.
    >
    > If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    >"tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] & "'")
    >= "Active" Then
    > Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime *
    >24) - 24 - DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    >* 24
    > Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    >DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    > Else
    > Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime *
    >24) - 24
    > Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    > End If
    >
    >I thought about using DateDiff but...
    >
    >?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    >carzy.



    The problem is that your start and end times are missing
    their date parts.

    You really should use DateDiff, but if you want to know
    about parts of an hour, you will need to calculate the
    number of minutes in the difference.

    Once you have the number of minutes in txtTimeDecimal, you
    can display it in txtTimeSpent using an expression:

    txtTimeSpent = txtTimeDecimal \ 60 & Format(txtTimeDecimal
    Mod 60, "\:00")

    --
    Marsh
    MVP [MS Access]
     
  4. Gina Whipp

    Gina Whipp
    Expand Collapse
    Guest

    Marshall,

    I am not sure I understand your reply, at least not all of it. I get my
    txtStartTime and txtEndTime not having the date part but I want to turn
    txtTimeSpent to txtTimeDecimal.

    The other part I don't understand is... you mean if I stored the date part
    in txtStartTime and txtEndTime DatDiff would work?

    Also note, txtTimeSpent always calcualtes correctly, it's when I try to
    convert to txtTimeDecimal I have the problem.

    Thanks for the time,
    Gina


    "Marshall Barton" <marshbarton@wowway.com> wrote in message
    news:1njnb2t7gm2fqarv8ub3a522lgqvdbi3mj@4ax.com...
    > Gina Whipp wrote:
    >>Also, I need to convert my time caculation to decimal. The below code
    >>actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM;
    >>then
    >>my Me.txtTimeDecimal = -15.00. If someone can explain why my
    >>txtTimeDecimal
    >>isn't working when the time crosses the day it would really help.
    >>
    >> If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    >>"tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] &
    >>"'")
    >>= "Active" Then
    >> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime
    >> *
    >>24) - 24 - DLookup("sLunchBreak", "tblShift",
    >>"[sShiftID]=Form.txtShiftID")
    >>* 24
    >> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    >>DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    >> Else
    >> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime
    >> *
    >>24) - 24
    >> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    >> End If
    >>
    >>I thought about using DateDiff but...
    >>
    >>?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    >>carzy.

    >
    >
    > The problem is that your start and end times are missing
    > their date parts.
    >
    > You really should use DateDiff, but if you want to know
    > about parts of an hour, you will need to calculate the
    > number of minutes in the difference.
    >
    > Once you have the number of minutes in txtTimeDecimal, you
    > can display it in txtTimeSpent using an expression:
    >
    > txtTimeSpent = txtTimeDecimal \ 60 & Format(txtTimeDecimal
    > Mod 60, "\:00")
    >
    > --
    > Marsh
    > MVP [MS Access]
     
  5. Gina Whipp

    Gina Whipp
    Expand Collapse
    Guest

    okay this works except for one part:

    Me.txtTimeDecimal = Format([txtTimeSpent], "hh") & "." &
    Format(txtTimeSpent, "nn")

    I want Format(txtTimeSpent, "nn") to show .5 for 30 minutes, .25 for 15
    minutes... I want fractions not minutes any ideas, I've tried all kinds of
    calculations.

    Thanks,
    Gina

    "Gina Whipp" <NotInterested@InViruses.com> wrote in message
    news:%23CmP15cqGHA.4760@TK2MSFTNGP05.phx.gbl...
    > Marshall,
    >
    > I am not sure I understand your reply, at least not all of it. I get my
    > txtStartTime and txtEndTime not having the date part but I want to turn
    > txtTimeSpent to txtTimeDecimal.
    >
    > The other part I don't understand is... you mean if I stored the date
    > part in txtStartTime and txtEndTime DatDiff would work?
    >
    > Also note, txtTimeSpent always calcualtes correctly, it's when I try to
    > convert to txtTimeDecimal I have the problem.
    >
    > Thanks for the time,
    > Gina
    >
    >
    > "Marshall Barton" <marshbarton@wowway.com> wrote in message
    > news:1njnb2t7gm2fqarv8ub3a522lgqvdbi3mj@4ax.com...
    >> Gina Whipp wrote:
    >>>Also, I need to convert my time caculation to decimal. The below code
    >>>actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM;
    >>>then
    >>>my Me.txtTimeDecimal = -15.00. If someone can explain why my
    >>>txtTimeDecimal
    >>>isn't working when the time crosses the day it would really help.
    >>>
    >>> If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    >>>"tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] &
    >>>"'")
    >>>= "Active" Then
    >>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 -
    >>> Me.txtEndTime *
    >>>24) - 24 - DLookup("sLunchBreak", "tblShift",
    >>>"[sShiftID]=Form.txtShiftID")
    >>>* 24
    >>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    >>>DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    >>> Else
    >>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 -
    >>> Me.txtEndTime *
    >>>24) - 24
    >>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    >>> End If
    >>>
    >>>I thought about using DateDiff but...
    >>>
    >>>?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    >>>carzy.

    >>
    >>
    >> The problem is that your start and end times are missing
    >> their date parts.
    >>
    >> You really should use DateDiff, but if you want to know
    >> about parts of an hour, you will need to calculate the
    >> number of minutes in the difference.
    >>
    >> Once you have the number of minutes in txtTimeDecimal, you
    >> can display it in txtTimeSpent using an expression:
    >>
    >> txtTimeSpent = txtTimeDecimal \ 60 & Format(txtTimeDecimal
    >> Mod 60, "\:00")
    >>
    >> --
    >> Marsh
    >> MVP [MS Access]

    >
    >
     
  6. Gina Whipp

    Gina Whipp
    Expand Collapse
    Guest

    Nevermind I got it...

    Me.txtTimeDecimal = Format([txtTimeSpent], "hh") + Format(txtTimeSpent,
    "nn") * 60 / 3600

    Thanks anyway!

    "Gina Whipp" <NotInterested@InViruses.com> wrote in message
    news:OksIXidqGHA.4812@TK2MSFTNGP04.phx.gbl...
    > okay this works except for one part:
    >
    > Me.txtTimeDecimal = Format([txtTimeSpent], "hh") & "." &
    > Format(txtTimeSpent, "nn")
    >
    > I want Format(txtTimeSpent, "nn") to show .5 for 30 minutes, .25 for 15
    > minutes... I want fractions not minutes any ideas, I've tried all kinds of
    > calculations.
    >
    > Thanks,
    > Gina
    >
    > "Gina Whipp" <NotInterested@InViruses.com> wrote in message
    > news:%23CmP15cqGHA.4760@TK2MSFTNGP05.phx.gbl...
    >> Marshall,
    >>
    >> I am not sure I understand your reply, at least not all of it. I get my
    >> txtStartTime and txtEndTime not having the date part but I want to turn
    >> txtTimeSpent to txtTimeDecimal.
    >>
    >> The other part I don't understand is... you mean if I stored the date
    >> part in txtStartTime and txtEndTime DatDiff would work?
    >>
    >> Also note, txtTimeSpent always calcualtes correctly, it's when I try to
    >> convert to txtTimeDecimal I have the problem.
    >>
    >> Thanks for the time,
    >> Gina
    >>
    >>
    >> "Marshall Barton" <marshbarton@wowway.com> wrote in message
    >> news:1njnb2t7gm2fqarv8ub3a522lgqvdbi3mj@4ax.com...
    >>> Gina Whipp wrote:
    >>>>Also, I need to convert my time caculation to decimal. The below code
    >>>>actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM;
    >>>>then
    >>>>my Me.txtTimeDecimal = -15.00. If someone can explain why my
    >>>>txtTimeDecimal
    >>>>isn't working when the time crosses the day it would really help.
    >>>>
    >>>> If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    >>>>"tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] &
    >>>>"'")
    >>>>= "Active" Then
    >>>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 -
    >>>> Me.txtEndTime *
    >>>>24) - 24 - DLookup("sLunchBreak", "tblShift",
    >>>>"[sShiftID]=Form.txtShiftID")
    >>>>* 24
    >>>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    >>>>DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    >>>> Else
    >>>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 -
    >>>> Me.txtEndTime *
    >>>>24) - 24
    >>>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    >>>> End If
    >>>>
    >>>>I thought about using DateDiff but...
    >>>>
    >>>>?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    >>>>carzy.
    >>>
    >>>
    >>> The problem is that your start and end times are missing
    >>> their date parts.
    >>>
    >>> You really should use DateDiff, but if you want to know
    >>> about parts of an hour, you will need to calculate the
    >>> number of minutes in the difference.
    >>>
    >>> Once you have the number of minutes in txtTimeDecimal, you
    >>> can display it in txtTimeSpent using an expression:
    >>>
    >>> txtTimeSpent = txtTimeDecimal \ 60 & Format(txtTimeDecimal
    >>> Mod 60, "\:00")
    >>>
    >>> --
    >>> Marsh
    >>> MVP [MS Access]

    >>
    >>

    >
    >
     
  7. Marshall Barton

    Marshall Barton
    Expand Collapse
    Guest

    I thought you were concerned about getting negative values
    for TimeSpent. If that's not the issue then I won't worry
    about it :-\

    Yes, if the date part were were in the fields with the time
    values, then DateDiff would not have a problem when your
    start and end times cross over midnight.

    To keep things in context, I'll respond to one of your other
    posts about the decimal calculation part of your question.
    --
    Marsh
    MVP [MS Access]


    Gina Whipp wrote:
    >I am not sure I understand your reply, at least not all of it. I get my
    >txtStartTime and txtEndTime not having the date part but I want to turn
    >txtTimeSpent to txtTimeDecimal.
    >
    >The other part I don't understand is... you mean if I stored the date part
    >in txtStartTime and txtEndTime DatDiff would work?
    >
    >Also note, txtTimeSpent always calcualtes correctly, it's when I try to
    >convert to txtTimeDecimal I have the problem.
    >
    >
    >"Marshall Barton" wrote
    >> Gina Whipp wrote:
    >>>Also, I need to convert my time caculation to decimal. The below code
    >>>actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM;
    >>>then
    >>>my Me.txtTimeDecimal = -15.00. If someone can explain why my
    >>>txtTimeDecimal
    >>>isn't working when the time crosses the day it would really help.
    >>>
    >>> If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    >>>"tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] &
    >>>"'")
    >>>= "Active" Then
    >>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime
    >>> *
    >>>24) - 24 - DLookup("sLunchBreak", "tblShift",
    >>>"[sShiftID]=Form.txtShiftID")
    >>>* 24
    >>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    >>>DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    >>> Else
    >>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime
    >>> *
    >>>24) - 24
    >>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    >>> End If
    >>>
    >>>I thought about using DateDiff but...
    >>>
    >>>?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    >>>carzy.

    >>
    >>
    >> The problem is that your start and end times are missing
    >> their date parts.
    >>
    >> You really should use DateDiff, but if you want to know
    >> about parts of an hour, you will need to calculate the
    >> number of minutes in the difference.
    >>
    >> Once you have the number of minutes in txtTimeDecimal, you
    >> can display it in txtTimeSpent using an expression:
    >>
    >> txtTimeSpent = txtTimeDecimal \ 60 & Format(txtTimeDecimal
    >> Mod 60, "\:00")
     
  8. Marshall Barton

    Marshall Barton
    Expand Collapse
    Guest

    I'm not sure that really works in all situations??

    The issue here is that you are treating a duration of time
    as if it were a time of day. I.e. 3pm - 9am is NOT 6am
    which is what you are doing. If it really does work, then
    you could simplify your code to:

    Me.txtTimeDecimal = Format(Me.txtTimeSpent, "hh\.nn")

    To display your time spent, I think this is more in keeping
    with your calculation approach and avoids thinking about
    the value as if it were a time of day:

    Me.txtTimeDecimal = Format(Me.txtTimeSpent * 24, "0.00")
    --
    Marsh
    MVP [MS Access]


    Gina Whipp wrote:

    >Nevermind I got it...
    >
    > Me.txtTimeDecimal = Format([txtTimeSpent], "hh") + Format(txtTimeSpent,
    >"nn") * 60 / 3600
    >
    >
    >"Gina Whipp" <NotInterested@InViruses.com> wrote
    >> okay this works except for one part:
    >>
    >> Me.txtTimeDecimal = Format([txtTimeSpent], "hh") & "." &
    >> Format(txtTimeSpent, "nn")
    >>
    >> I want Format(txtTimeSpent, "nn") to show .5 for 30 minutes, .25 for 15
    >> minutes... I want fractions not minutes any ideas, I've tried all kinds of
    >> calculations.
     
  9. Gina Whipp

    Gina Whipp
    Expand Collapse
    Guest

    Hmmm, yes my calculations work in every circumstance. I was not concerned
    about the negative values as much as I was concerned it wasn't even givng me
    the correct values but thanks to your reply I understand why.

    My txtStartTime and txtEndTime are formatted with no date BUT calculate
    txtTimeSpent (Short Time) correctly, it's when I try to turn it to
    txtTimeDecimal there is the problem. txtTimeDecimal is is fixed.

    Thanks,
    Gina

    P.S. Just 'cause I got it right doesn't mean I can't learn something for the
    next time! :cool:

    "Marshall Barton" <marshbarton@wowway.com> wrote in message
    news:eek:o4ob21a8fiil9do52tsqid3reod87qhl5@4ax.com...
    >I thought you were concerned about getting negative values
    > for TimeSpent. If that's not the issue then I won't worry
    > about it :-\
    >
    > Yes, if the date part were were in the fields with the time
    > values, then DateDiff would not have a problem when your
    > start and end times cross over midnight.
    >
    > To keep things in context, I'll respond to one of your other
    > posts about the decimal calculation part of your question.
    > --
    > Marsh
    > MVP [MS Access]
    >
    >
    > Gina Whipp wrote:
    >>I am not sure I understand your reply, at least not all of it. I get my
    >>txtStartTime and txtEndTime not having the date part but I want to turn
    >>txtTimeSpent to txtTimeDecimal.
    >>
    >>The other part I don't understand is... you mean if I stored the date
    >>part
    >>in txtStartTime and txtEndTime DatDiff would work?
    >>
    >>Also note, txtTimeSpent always calcualtes correctly, it's when I try to
    >>convert to txtTimeDecimal I have the problem.
    >>
    >>
    >>"Marshall Barton" wrote
    >>> Gina Whipp wrote:
    >>>>Also, I need to convert my time caculation to decimal. The below code
    >>>>actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM;
    >>>>then
    >>>>my Me.txtTimeDecimal = -15.00. If someone can explain why my
    >>>>txtTimeDecimal
    >>>>isn't working when the time crosses the day it would really help.
    >>>>
    >>>> If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    >>>>"tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] &
    >>>>"'")
    >>>>= "Active" Then
    >>>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 -
    >>>> Me.txtEndTime
    >>>> *
    >>>>24) - 24 - DLookup("sLunchBreak", "tblShift",
    >>>>"[sShiftID]=Form.txtShiftID")
    >>>>* 24
    >>>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    >>>>DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    >>>> Else
    >>>> Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 -
    >>>> Me.txtEndTime
    >>>> *
    >>>>24) - 24
    >>>> Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    >>>> End If
    >>>>
    >>>>I thought about using DateDiff but...
    >>>>
    >>>>?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    >>>>carzy.
    >>>
    >>>
    >>> The problem is that your start and end times are missing
    >>> their date parts.
    >>>
    >>> You really should use DateDiff, but if you want to know
    >>> about parts of an hour, you will need to calculate the
    >>> number of minutes in the difference.
    >>>
    >>> Once you have the number of minutes in txtTimeDecimal, you
    >>> can display it in txtTimeSpent using an expression:
    >>>
    >>> txtTimeSpent = txtTimeDecimal \ 60 & Format(txtTimeDecimal
    >>> Mod 60, "\:00")
     
  10. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi gina,

    what you are adding/subtracting should be a Date and a Time,
    not just a time. Since Date is the whole number and Time is
    the decimal part of a number, you can add the 2 together.

    dim mDateAndTime as Date
    mDateAndTime = [DateField] + [TimeField]

    It is best to just store Date and Time together.

    Warm Regards,
    Crystal
    Microsoft Access MVP 2006

    *
    Have an awesome day ;)

    remote programming and training
    strive4peace2006 at yahoo.com

    *

    Gina Whipp wrote:
    > Hey All,
    >
    > Also, I need to convert my time caculation to decimal. The below code
    > actully worked until txtStartTime = 03:00 PM and txtEndTime = 01:00 AM; then
    > my Me.txtTimeDecimal = -15.00. If someone can explain why my txtTimeDecimal
    > isn't working when the time crosses the day it would really help.
    >
    > If Not IsNull(Me.txtStartTime) And DLookup("apEmploymentStatus",
    > "tblAssociateProfile", "[apAssociateID]=" & "'" & Me![txtAssociateID] & "'")
    > = "Active" Then
    > Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime *
    > 24) - 24 - DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    > * 24
    > Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime) +
    > DLookup("sLunchBreak", "tblShift", "[sShiftID]=Form.txtShiftID")
    > Else
    > Me.txtTimeDecimal = Abs((Me.txtStartTime - 1) * 24 - Me.txtEndTime *
    > 24) - 24
    > Me.txtTimeSpent = (Me.txtStartTime - 1 - Me.txtEndTime)
    > End If
    >
    > I thought about using DateDiff but...
    >
    > ?DateDiff("h","03:30 PM ","01:00 AM") comes up with -14 it's driving me
    > carzy.
    >
    >
    > Thanks in advanceGina Whipp
    >
    >
     

Share This Page