The Math Forum

Search All of the Math Forum:

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

Math Forum » Discussions » Software » comp.soft-sys.matlab

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

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]

Posts: 4
Registered: 6/22/11
Comparison of time entries
Posted: Apr 24, 2012 9:50 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

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?

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2018. All Rights Reserved.