I have a spread sheet that shows when someone checked in/out and the time
that they were removed from the log. I want to calculate the time between
the check out time and the time that they were removed.
Check Out Time(column C) and Removed Time(column F) are both set up as
mm/dd/yyyy hh:mm:ss AM/PM
I created a field called elapsed time and put the following formula in.
=TEXT(F2-C2,"hh:mm:ss")
I hit enter and I get #VAUE!

Any ideas why/