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/

Your formula works for me. However, if the date/time in C2 is after the
date/time in F2, I got the error.

"Michelle" wrote in message
...
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/

It would seem that one of the times is invalid, maybe text not a number.

BTW, F2-C2 and formatted as time will suffice.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Michelle" wrote in message
...
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/