Calculating Elapsed Time

[ep820]

I have to calculate time elasped from start to end of assignments. Sometimes this will begin on one day and end during the next day. How do I calculate the elapsed time and also check if the date is different?

Would I write a script that checks the dates, some sort of IF THEN statement? Thanx, Rick

[signal]

Elapsed time in hours =

Round((((end date - start date) * 86400) + end time - start time)/60/60, 2)