I'm not sure I've understood, but I guess @row[2,3] are the starting hour and minute, and @row[4,5] are the ending hour and minute. You want to get the total elapsed time, presumably in hours and minutes.

If so, don't round the minutes up to hours; multiply the hour by 60 to get minutes, add it to the minutes, then substract start from end (everything in the smallest units): 

$start_total = 60*$row[2] + $row[3];
$end_total = 60*$row[4] + $row[5];
$total_time = $end_total - $start_total;   # in minutes

[download]
If you want to render the $total_time as hours and minutes, use integer division and remainder by 60: 
$total_hr = int($total_time/60)  # $total_time >= 0 
$total_min = $total_time%60;

[download]
You can then use sprintf or something to render it in a nice "hh:mm" format.

HTH

In reply to Re: Time Totaling by VSarkiss
in thread Time Totaling by nlafferty

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • 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:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.