need urgent help

From: Bhishm <bhishms_at_gmail.com>
Date: Mon, 19 Nov 2007 23:11:14 -0800 (PST)
Message-ID: <72c451aa-cdd5-4a33-98f8-eaf77c9fde6f@p69g2000hsa.googlegroups.com>

Hi,

I am creating a attendance sheet software for inhouse use.

my data is like this:-

---

| name     |          login time                   |   logout
time                 |


------------------------------------------------------------------------------------------------

|  a          |   2007-11-10 12:00:00           |  2007-11-10

16:00:00 |

---

| b | 2007-11-10 15:00:00 | 2007-11-10 18:00:00 |

---

My requirement:-

I want to generate an hourly report like this:-

---

date                    time range                total people logged

in

---

 2007-11-10          0 -2                                0


--------------------------------------------------------------------------------------------

2007-12-10           2-4                                 0


--------------------------------------------------------------------------------------------

.
.

---

 2007-11-10        12-14                              1


-------------------------------------------------------------------------------------------

2007-11-10         14-16                              2


--------------------------------------------------------------------------------------------

2007-11-10         16-18                              1


------------------------------------------------------------------------------------------------

.
.

---

2007-11-10        22-24                               0


--------------------------------------------------------------------------------------------

This is what I want to creat , but I don't know how can I generate such kind of report.

Can you please guide me for the same. Please reply urgently.

Thanks & Regards,
Bhishm Received on Tue Nov 20 2007 - 01:11:14 CST