Counting minutes formula - problem with after midnight -

[santon]

Hi guys. I have a problem with formula when it comes down to this situation shown on the picture.


When my first entered time is before midnight, and second is after, it won't work.
I have created a calculated field with this expression :

(Hour([End_time]-[Start_time])*60)+Minute([End_time]-[Start_time])

It is supossed to calculate minutes from two times, start and end, and it works just fine,
until it comes up to a situation on the picture. Also, the start and end time are "Date/Time" type of data in my table.

Can you help me fix this?

[Bob Fitz]

I think your problem is because Access doesn't know that 0:15 is a time in the next day.
Allen Browne has some advice on time calculation: http://allenbrowne.com/casu-13.html

[santon]

I think your problem is because Access doesn't know that 0:15 is a time in the next day.
Allen Browne has some advice on time calculation: http://allenbrowne.com/casu-13.html

Hi, thank you for you help, although it didn't work for me, I have found a solution.
I am posting it here, so if anybody have the same problem, here is the solution that calculates the minutes just fine

(Hour([Start_time]-1-[End_time])*60)+Minute([Start_time]-1-[End_time])

Cheers

[CarlettoFed]

Don't say you've solved it, look at this example when the difference between days is greater than 1.

[Welshgasman]

Why not just include the date portion and then datediff("n",starttime,endtime) ?

[santon]

Thank you all for your advices and help