Search All of the Math Forum:

Views expressed in these public forums are not endorsed by NCTM or The Math Forum.

Notice: We are no longer accepting new posts, but the forums will continue to be readable.

Topic: Comparison of time entries
Replies: 11   Last Post: Apr 25, 2012 1:33 PM

 Messages: [ Previous | Next ]
 Johannes Posts: 4 Registered: 6/22/11
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 Excel-File 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?

Date Subject Author
4/24/12 Johannes
4/24/12 dpb
4/24/12 Steven Lord
4/25/12 Johannes
4/25/12 dpb
4/25/12 dpb
4/25/12 dpb
4/25/12 Barry Williams
4/25/12 Johannes
4/25/12 dpb
4/25/12 Barry Williams
4/25/12 Steven Lord