Re: Time Calculation

not sure why it would return value, unless the value in D3 is actually
text in which case you'll have to convert it to a date.

if you want to know how long, to the second, is left, you will have to
create a string yourself, such as:

=DAY(D3-NOW()) & " days, " & HOUR(D3-NOW()) & " hours, " &
MINUTE(D3-NOW()) & " minutes, " & SECOND(D3-NOW()) & " seconds"

The pattern should be obvious so you can make it as complex as you
need.

Rob

.

Relevant Pages

  • Re: require fails yet module exists in @INC path...?
    ... If you want to use either of the last 2, then $class needs to be a string ... Rob ... Prev by Date: ...
    (comp.lang.perl.misc)
  • regular expressions, word matching
    ... I want to count words in a string which are NOT with length 10. ... word is a sequence of symbols different from ' '. ... How to set to match not this pattern? ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • java.regex
    ... how to apply pattern to a file. ... In matcher instead of using string I want to use a "file.txt". ... Prev by Date: ...
    (comp.lang.java.help)
  • java.regex
    ... How to apply pattern to a file. ... In matcher instead of using string I want to use "file.txt". ... Prev by Date: ...
    (comp.lang.java.help)
  • Re: Regex : regular expression problem
    ... means as few repeats as possible. ... the pattern). ... >> I want to change the string to the following with regex. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)