Date Time Help

[mr moe]

This is very tricky I hope that someone can help please. I have a table that I imported to access, it has four columns, start date start time finish date finish time. I need to generate a report to show items that took more than 30 hrs, ontop of this items that fall within friday have a different senario. Someone gotta help.

 

[pbaldy]

You could combine the start date & time and the finish date & time, then use DateDiff to calculate the difference.

 

[mr moe]

got it thanks!!!!!!!!!!!!!!!!1