Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: Problem in Time

  1. #1
    Regular Coder
    Join Date
    Aug 2010
    Posts
    713
    Thanks
    165
    Thanked 0 Times in 0 Posts

    Problem in Time

    Hi..


    I got an issue in getting the total time.

    I have this code to get the sum of total time:

    Code:
    $result = mysql_query("INSERT INTO payroll.casual_hours(EMP_NO, Hours) SELECT EMP_NO, sec_to_time(SUM(time_to_sec(Rendered))) FROM payroll.casual_att WHERE DATE_FORMAT(LOGOUT, '%W') IN ('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday') GROUP BY EMP_NO") or die(mysql_error());
    Rendered:
    09:00:00
    09:00:00
    09:00:00
    08:00:00
    08:00:00
    07:48:00

    and the result of this is 50:48

    but I need result is 50:80

    the minutes is divided to 60

    Is there any way to get the 50:80 result.


    Thank you so much..

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,538
    Thanks
    8
    Thanked 1,093 Times in 1,084 Posts
    And what is 50:80 ?
    Is that like 51 hours and 20 minutes?
    How does your 50:48 relate to 50:80 in your example?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •