Search All of the Math Forum:
Views expressed in these public forums are not endorsed by
Drexel University or The Math Forum.



Comparison of time entries
Posted:
Apr 24, 2012 9:50 AM


Hi, I really hope you can help me.
I'm looking for a way to compare two time entries in an ExcelFile effectively. The entries are given in the form 'hh:mm:ss' e.g. '14:28:30'.
I would like to figure out the chronological order of the two entries. So, how is it possible to determine, that '17:50:23' is later than '17:45:33' for example?
I tried to use the function datenum.
a =datenum('14:52:49') = 7.364215839004630e+005 b =datenum('15:50:49') = 7.363616255671296e+005 _____________________________________________
a  b = 59.958333333372138
Why is the result negative?



