The old 24 hour clock problem

[Wes]

Hi all,

I'm a frequent excell user but Ive come to a point that I need to use access for some of my tasks ...

What I have is three text boxes. text box 1 = StartTime, text box 2 = EndTime and text box 3 = interval.

text box 1 and 2 contain as you can probably tell start and end times in a 24 hour format. What I need to do is have the interval text box calculate a value of time in hours and minutes should the ne time go into the next day. So if the start time was 23:50 and the end time was 00:15 then the time interval would be 00:25 not the negative number that is given.

Any help would really be appreciated.

Thanks

Wes

 

[Norie]

Wes

How are you currently calculating the difference?

Try this expression to return the minutes

IIf([StartTime]>[EndTime],(24*60)-DateDiff("n",[EndTime],[StartTime]),DateDiff("n",[StartTime],[EndTime]))