Adding together time hh:mm:ss to a total

Hi,

I'm building a time report system for work and I want to show the total hours and minutes a project have taken but can't get it to work ...

I have a database (MySQL) in one table I have the date in one colum and the time in one colum. The date i formated like this YYYY-MM-DD and set to date. And the TIME is like this HH:mm:ss.
My code looks like this right now...

[PHP]<?php
$sql="select
p.id, p.date, p.time
from rap_time p
order by 1 desc";
$rows = mysql_query($sql);
$totaltime = 0;
while($row = mysql_fetch_array($rows)) {

echo"$row[1]";
echo", ";
echo"$row[2]";
echo"<br />";
$totaltime = $totaltime + $row[2];
}
echo"$totaltime";
?>
[/PHP]
The $totaltime just shows the total hours and it does not count the hours and minutes together.
So if I have an output of times that looks like this:
01:10:00
01:13:00
01:40:00
the totaltime will show:
3
Not 04:03:00
And yes I'm a noob on PHP and SQL...

May 14 '07 #1

Subscribe Post Reply

27056

Lick

You will have to write code that first counts the seconds and see if they overflow the 59 seconds limit. If they overflow, you add 1 to the minute calculation.

Next, you count the minutes and see if they overflow the 59 minutes limit. If they overflow, you add 1 to the hours calculation.
Note: don't forget to add the 1 from the previous calculation, if applicable.

Next, you count the hours and if applicable, add 1 from the previous calculation.

May 14 '07 #2

pbmods

5,821

Expert 4TB

Here's how I would do it:

Assuming the times don't span multiple days, pick a random day. For example, '2007-05-14' (to pick a random one). Then prepend the date to your times and calculate their unix timestamps.

Then, all you have to do is add up the differences between your times and midnight of the same day:

Expand|Select|Wrap|Line Numbers

 
var $date = '2007-05-14';

var $datetime = strtotime("$date 00:00:00");
 
//    These are examples; you'll probably want to pull your numbers from the DB.

var $times = array(

    '01:15:45',

    '03:11:02',

    '10:15:45'

);
 
var $sum = 0;

foreach($times as $time) {

    $sum += strtotime("$date $time") - $datetime;

}
 
//    $sum holds the total number of seconds of all three times.

print($sum);

When the loop executes the first time, we are computing the difference between two datetimes:

Expand|Select|Wrap|Line Numbers

 
$sum += strtotime('2007-05-14 01:15:45') - strtotime('2007-05-14 00:00:00');

You're taking the number of seconds from January 1, 1979 (or something like that) until May 14, 2007 at 1:15 AM and 45 seconds. Then you take the number of seconds from January 1, 1979 until May 14, 2007 at midnight and subtract the two numbers.

Since May 14, 2007 01:15:45 occurred exactly 1 hour, 15 minutes and 45 seconds after May 14, 2007 00:00:00, $sum has just been +='ed to the number of seconds in 1 hour, 15 minutes and 45 seconds (4515).

Continue through the loop with the rest of your values, and you've got yourself a handy little time-summer.

Now the trick comes into play when your times span >1 day. But the fix for that isn't too difficult ;)

May 15 '07 #3

skillednerd

Expand|Select|Wrap|Line Numbers

 list($h, $m, $s) = split('[:]', $time_1_here);

list($h2, $m2, $s2) = split('[:]', $time_2_here);
 
$h = ($h * 60) * 60;

$m = $m * 60;

$h2 = ($h2 * 60) * 60;

$m2 = $m2 * 60;
 
$x = $h + $m + $s;

$x2 = $h2 + $m2 + $s2;
 
$y = $x + $x2;
 
$y = $y / 60;

$y = $y / 60;
 
echo $y;

[Please use CODE tags when posting source code. Thanks! --pbmods]

Jul 2 '07 #4

kovik

1,044

Expert 1GB

You know, the reason timestamps were ever used is because you can calculate the difference between them with simple subtraction. You can use mktime() to turn the dates into timestamps, and then do this:

Expand|Select|Wrap|Line Numbers

 $end - $start = $timeTaken;

$years = date('Y', $timeTaken) - 1970; // because timestamps start at 1970

$months = date('n', $timeTaken);

$days = date('j', $timeTaken);

Jul 2 '07 #5

helalreza

Expand|Select|Wrap|Line Numbers

 <body>

<input type="time" step="1" id="startTimeInput"  name="start_time" value=""><br>     <!--   write as like       02:31:55   -->

<input  type="time" step="1" id="endTimeInput"  name="end_time" value=""><br>

<button id="calcBtn">Seconds</button><br>

<div id="result"></div>

<script type="text/javascript" src="js/jquery.js"></script>

<script type="text/javascript">

document.getElementById('calcBtn').onclick = function(){

    var startTime = document.getElementById('startTimeInput').value;

    var endTime = document.getElementById('endTimeInput').value;

  var result = getDeltaSeconds(startTime, endTime);

  document.getElementById('result').innerHTML = result + ' sec';

}

function getDeltaSeconds(startTime, endTime){

    var startTimeSeconds = getSeconds(startTime);

  var endTimeSeconds = getSeconds(endTime);

  return endTimeSeconds - startTimeSeconds;    

}

function getSeconds(timeString){

    var parts = timeString.split(' ');

  var time = parts[0];

  var ampm = parts[1];

  var timeParts = time.split(':');

  var seconds = Number(timeParts[2]) + Number(timeParts[1]*60) + Number(timeParts[0]*60*60);

  return ampm == 'AM' ? seconds : seconds + 12*60*60;

}

</script>

</body>

Oct 4 '16 #6

Similar topics

Seconds as hh:mm:ss

by: Able | last post by:

Dear friends I need to format seconds as hh:mm:ss. I see a lot of coding transforming seconds to hh:mm:ss. Somebody know a short way? Regards Able

Visual Basic .NET

how to get HH:mm:ss format of Now.ToShortTimeString?

by: Rich | last post by:

Now.ToShortTimeString returns 9:13 PM. I would like to get this in miliatry time with seconds included 21:13:45 (or something like that - just military time with seconds). How can this be...

Visual Basic .NET

Convert seconds to 00:00:00 (HH:MM:SS) format. Please help

by: Michael Barrido | last post by:

I have this for example: Dim iSeconds as int32 = 3600 '3600 seconds is one hour How do i convert it to "01:00:00" ? Please help. Thanks in advance!

.NET Framework

why DateTime.ToString("hh:mm:ss") give 12:00:00 rather than 00:00:

by: Jason Chan | last post by:

DateTime mydate = new DateTime(2006,1,1,0,0,0); string testStr = mydate.ToString("hh:mm:ss"); //return 12:00:00 mydate = new DateTime(2006,1,1,1,0,0) testStr = mydate.ToString("hh:mm:ss");...

ASP.NET

how to convert date time format as yyyyddmm hh:mm:ss in c#?

by: nirmalsingh | last post by:

i am getting date format in string as 30-11-2006 05:59:44 PM . i want to convert in the format of yyyy-mm-dd hh:mm:ss to sore it in mysql database. Help me with sample coding plz..

.NET Framework

Milliseconds to HH:MM:SS ??

by: sunbin | last post by:

hi, How can i get the FLV file or any type of video file's duration in HH:MM:SS or HH:MM:SS:FF format from milliosecond ? I already got duration in millisecond. PHP script needed ... Plz help...

PHP

Displaying unix time into HH:mm:ss:ms format

by: unknown66 | last post by:

hello, I have a time value in unix time that I would like to convert into a time format of hh:mm:ss:ms. For example, I have this number, 1172234138451, that I would like to be in the hh:mm:ss:ms...

Python

how to convert the time which is in hh:mm:ss to just mm:ss

by: seshu | last post by:

Hi every body to morning my cousine has show his application and also his live db in that to sav the length of all the voice files he has saved in time format ie he took the datatype of time now i...

MySQL Database

how to convert the time which is hh:mm:ss to mm:ss

by: seshu | last post by:

Hi every body to morning my cousine has show his application and also his live db in that to sav the length of all the voice files he has saved in time format ie he took the datatype of time now i...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General