Calculating time AT midnight

[atom]

Hello everyone,



I have come across this problem where I have to calculate time difference at midnight (e.g StartTime = 22:00 , EndTime= 00:00)

The problem occurs when I enter EndTime :00:00 . Access converts it to 12:00 PM not AM so no matter what function I have tried to use the result is : -10

Is there a way to solve this
Thank you in advance

[boblarson]

The end time is #12:00:00 AM#

not :00:00.

[boblarson]

Oh, and you should always include the date in the time calculations. It will make your life SO much easier.

[RuralGuy]

See if this link helps: http://access.mvps.org/access/datetime/date0004.htm

[June7]

See if these offer idea
http://us.generation-nt.com/answer/d...204242211.html

http://forums.devarticles.com/micros...tml#post467123

http://allenbrowne.com/casu-13.html

[atom]

Oh, and you should always include the date in the time calculations. It will make your life SO much easier.

How can I do that?

[atom]

Thank you all for your replies great help!!

[atom]

I used IIf([StartTime]>[FinishTime];(24-DateDiff("n";[FinishTime];[StartTime])/60);(DateDiff("n";[StartTime];[FinishTime]))/60).
It workes like a charm

[boblarson]

How can I do that?

I know you have it working now, but you should always use date/time fields instead of just the time. If someone logs in or out you include the date too. Then it is so very easy to use and doesn't require the formula you needed to use.

[atom]

I have set the field to date/time where the user adds time but as far I can see if he double clicks date appears at 1900!Can I bypass this so that the user enters the date too?
By now I have 2 fields for Start/Finish time and 1 field for date.

[boblarson]

How does the user set the time? Is it "real time" so like they enter when they start at the time they start or do they add it in at some other time? If it is real time, then you can just have a button which adds the date and time by using NOW.

Private Sub YourButtonNameHere_Click()
   Me!StartDateTimeFieldNameHere = Now
End Sub

If at another time, you can use a date/time picker to select the date and then an unbound text box where they enter the time only and in the After Update of that text box you could use:

Private Sub UnBoundTextboxNameHere_AfterUpdate()
   Me!YourDateTimeFieldNameHere = Me.DatePickerNameHere.Value + Me.UnBoundTextBoxNameHere
End Sub

[atom]

Yes I think this might work!
Thank you for your help