I am trying to use a formula to determine the current time elapsed. I have a date time in cell A3 and I attempted using the formula =now()-A3 and keep getting the #VALUE error. How can I determine the total time elapsed from the date/time I have input in A3 to the current date/time?
Hello kschmit1,
What you tried will work if A3 contains a valid date/time value - if you get #VALUE! error then A3 must be uncoercable text.
What result do you get with =ISNUMBER(A3)?
What value can you see in A3 exactly?
Audere est facere
I get a result of False
I have A3 formatted as 9/13/17 8:00AM using the Date Format, I have the cell I am trying to input this formula currently formatted the same, not sure if that is the iss but when it was formatted as general it did not work either.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks