On Sat, 17 May 2008 09:17:59 -0700 (PDT), MJKelly < XXXX@XXXXX.COM >
I don't understand your questions:
What is the difference between "finish time" and "end time"?
Make what easier?
If you are writing about computing elapsed time if the shift spans midnight,
them =MOD(EndTime-StartTime,1) is about as easy as it gets.
If you are writing about deciding whether you entered a start time that was
after the end time, and the only information you have is that a shift may not
span 6AM, then maybe: