Ok-
I've been reading threads for the last 2 days on this subject but I've been unable to wrap my head around this problem.
I have two fields on my form
TimeIn and TimeOut
All events are stored in 24 hour time format. I need to subtract the TimeIn from the TimeOut to get the total time. Simple right? [TimeIn]-[TimeOut] works execpt when the time spans the 24 hour mark. (e.g. 23:30 - 02:30 = 21:00 when the value should be 2:00). The DateDiff fucntion works in the same way. The other problem is my forms are based on one day only. (for example if an event occurs at 23:40 and goes to 04:30 it is still considered to have happened during the date of 23:40, therefore there is only one 'date' on the form), the reason why DateDiff doesn’t work.
Any Ideas?
Nick
I've been reading threads for the last 2 days on this subject but I've been unable to wrap my head around this problem.
I have two fields on my form
TimeIn and TimeOut
All events are stored in 24 hour time format. I need to subtract the TimeIn from the TimeOut to get the total time. Simple right? [TimeIn]-[TimeOut] works execpt when the time spans the 24 hour mark. (e.g. 23:30 - 02:30 = 21:00 when the value should be 2:00). The DateDiff fucntion works in the same way. The other problem is my forms are based on one day only. (for example if an event occurs at 23:40 and goes to 04:30 it is still considered to have happened during the date of 23:40, therefore there is only one 'date' on the form), the reason why DateDiff doesn’t work.
Any Ideas?
Nick