Dude! Read carefully the advices that we gave you !
I guess boo_radley was correct in pointing out "what exactly do you mean by decimal?" , cause judging by the way you are doing this, you somehow got our advices wrong
Everybody was telling you to either:
- use epoch time, or
- use the database's native time format
We were trying to tell you that you can't reliably compute the elapsed time by just having
the starting hour, starting minute, end hour and end minute. If you want to do that, you *must* assume that those times were recorded within the same day,
between 00:00am to 23:59pm. Otherwise, you *always*
need to know the date to compute the time elapsed
Is there some reason you can't change those entries?
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
| |
For: |
|
Use: |
| & | | & |
| < | | < |
| > | | > |
| [ | | [ |
| ] | | ] |
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.