How do I find the difference between 2 times

[jk12]

Hi, I have the following expression in my query;

Worked Hours: DateDiff("h",[Start Time],[Finish Time])-[Breaks]

Start time and finish time appear as hh:mm and breaks is stored as a decimal i.e. 15min is 0.25, 30min is 0.5, 1 hour is 1.

The expression works fine when e.g Start 07:00 Finish 17:00 with breaks as 30min(0.5) gives the correct value of 9.5 hours worked but if the finish time was say 17:30, rather then show the correct value of 10 hours worked, it shows the wrong value of 9.5.

Could someone please tell me where I have one wrong and how to sort the problem, or offer me a different solution.

Thanks

 

[Jon K]

Worked Hours: ([Finish Time]-[Start Time])*24-[Breaks]

See explanation in this thread:-
How to work out Hrs
http://www.access-programmers.co.uk/forums/showthread.php?t=107276
.

 

[jk12]

Cheers works great now!