Search results

Worked a treat, Many Thanks

Hi Paul Thanks for your reply, my calculation works for same day calculations but not for ones crossing over at midnight eg StartTime 23:30 FinishTime 00:15 I want a return value of 45 but I am getting -1395 I put the DateDiff expression in the subform query as follows BoilTime...

I have a subform in which I want to calculate the difference between a start time and finish time, the problem I am having is when the start time is on a different date to the finish time Start 23:15 on 14th Jan finish 00:015 on 15th Jan, also I want the answer to be the number of minutes. The...