[gnumeric] fix ODF.TIME description and add notes to TIME and ODF.TIME

[Andreas J. Guelzow <guelzow src gnome org>]

commit ef0a39ffbea2d8399e3e8321e12828c822e80332
Author: Andreas J Guelzow <aguelzow pyrshep ca>
Date:   Wed May 23 13:29:07 2012 -0600

    fix ODF.TIME description and add notes to TIME and ODF.TIME
    
    2012-05-23  Andreas J. Guelzow <aguelzow pyrshep ca>
    
    	* functions.c (help_time): add note about the range of values
    	(help_odf_time): ditto, and fix description

 plugins/fn-date/ChangeLog   |    5 +++++
 plugins/fn-date/functions.c |    8 ++++++--
 2 files changed, 11 insertions(+), 2 deletions(-)
---
diff --git a/plugins/fn-date/ChangeLog b/plugins/fn-date/ChangeLog
index 5e45e33..21cb216 100644
--- a/plugins/fn-date/ChangeLog
+++ b/plugins/fn-date/ChangeLog
@@ -1,3 +1,8 @@
+2012-05-23  Andreas J. Guelzow <aguelzow pyrshep ca>
+
+	* functions.c (help_time): add note about the range of values
+	(help_odf_time): ditto, and fix description
+
 2012-05-22  Andreas J. Guelzow <aguelzow pyrshep ca>
 
 	* functions.c (help_time): adjust information
diff --git a/plugins/fn-date/functions.c b/plugins/fn-date/functions.c
index 57fdcec..6c8fb61 100644
--- a/plugins/fn-date/functions.c
+++ b/plugins/fn-date/functions.c
@@ -423,7 +423,9 @@ static GnmFuncHelp const help_time[] = {
         { GNM_FUNC_HELP_ARG, F_("minute:minute within the hour")},
         { GNM_FUNC_HELP_ARG, F_("second:second within the minute")},
 	{ GNM_FUNC_HELP_DESCRIPTION, F_("The TIME function computes the fractional day after midnight at the time given by @{hour}, @{minute}, and @{second}.") },
-	{ GNM_FUNC_HELP_NOTE, F_("If any of @{hour}, @{minute}, and @{second} is negative, #NUM! is returned")},
+	{ GNM_FUNC_HELP_NOTE, F_("While the return value is automatically formatted to look like a time between 0:00 and 24:00, "
+				 "the underlying serial time value is a number between 0 and 1.")},
+ 	{ GNM_FUNC_HELP_NOTE, F_("If any of @{hour}, @{minute}, and @{second} is negative, #NUM! is returned")},
         { GNM_FUNC_HELP_EXAMPLES, "=TIME(12,30,2)" },
         { GNM_FUNC_HELP_EXAMPLES, "=TIME(25,100,18)" },
 	{ GNM_FUNC_HELP_EXCEL, F_("This function is Excel compatible.") },
@@ -457,7 +459,9 @@ static GnmFuncHelp const help_odf_time[] = {
         { GNM_FUNC_HELP_ARG, F_("hour:hour")},
         { GNM_FUNC_HELP_ARG, F_("minute:minute")},
         { GNM_FUNC_HELP_ARG, F_("second:second")},
-	{ GNM_FUNC_HELP_DESCRIPTION, F_("The TIME function computes the time given by @{hour}, @{minute}, and @{second} as a fraction of a day.") },
+	{ GNM_FUNC_HELP_DESCRIPTION, F_("The ODF.TIME function computes the time given by @{hour}, @{minute}, and @{second} as a fraction of a day.") },
+	{ GNM_FUNC_HELP_NOTE, F_("While the return value is automatically formatted to look like a time between 0:00 and 24:00, "
+				 "the underlying serial time value can be any number.")},
         { GNM_FUNC_HELP_EXAMPLES, "=ODF.TIME(12,30,2)" },
         { GNM_FUNC_HELP_EXAMPLES, "=ODF.TIME(25,100,-18)" },
 	{ GNM_FUNC_HELP_ODF, F_("This function is OpenFormula compatible.") },