Jump to content

find the difference


sandy1028

Recommended Posts

          0 | 2008-06-10 15:30:01 | A
           1 | 2008-06-10 15:40:01 | A  // Calcute timestamp as 10 min
           1 | 2008-06-10 15:50:01 |A //Skip
           1 | 2008-06-10 16:00:01 |A  //Skip
           1 | 2008-06-10 16:10:01 |A   //Skip
           0 | 2008-06-10 16:20:01 |A   // Calcute timestamp as 10 min
           1 | 2008-06-10 16:30:01 |A  
           1 | 2008-06-10 16:40:01 |A  //Skip
           1 | 2008-06-10 16:50:01 |A  //Skip
           1 | 2008-06-10 17:00:01 |A  //Skip
           0 | 2008-06-10 17:10:01 |A   
           1 | 2008-06-10 17:20:01 |A   //Calcute difference as 10 min
           1 | 2008-06-10 17:30:01 |A   
           0 | 2008-06-10 17:40:01 |A
           0 | 2008-06-10 17:50:01 |A //Clauculate as 20 min

 

and how to push into array as it shows like this in the table

         

The fields are Status, imestamp and Name.

As in the above example

It should display as

 

In the table the

 

Name| Start Time | End Time | Difference

 

A | 2008-06-10 15:30:01 |2008-06-10 15:40:01 | 10

A | 2008-06-10 16:10:01  | 2008-06-10 16:20:01 | 10

 

 

Based on the status 0 timestamp difference has to be calculated.

 

Please help me.

 

 

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/109553-find-the-difference/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.