#VALUE! in Time Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting just the time portion 5
Calculating elapsed time 5
Calculating/displaying elapsed time TOTALS 3
Format Cells to calculate hours and minutes taken to complete task 5
Calculate cumulative elapsed time in Excel? 4
Calculating a future date using system clock & time remaining 1
want to track time while paste value in multiple column of same roe 1
separating date and time 5

Back
Top