interval in specific time

[pan_arshad]

hi
i need to do time interval..
let say
in cell A2 = 9/11/2012 12:15:34 AM
in cell B2 = 9/11/2012 02:15:54 AM
in cell C1 = 00:00-01:00
in cell D1 = 01:00-02:00
in cell E1 = 02:00-03:00

the time interval between cell A2 & cell B2 = 2 hours. so, i need to separate 2 hours in column C2,D2 and E2. so the time interval in column C2 is 45 min, in column D2 is 60 min and in column E2 is 15 min. i dont know how to seperate 2 hours into specific time range. can anyone help me on this.?

thank you...

[FDibbins]

if those are the exact time intervals you want, or if thats the ratio yo are looking for, multiply your time by 0.375 (45 mins), 0.125 (15 mins) and 0.5 (1 hr)

[pan_arshad]

thank you for your response.
i'm trying to create a formula so that it will be easier for me because the data is about 10000++, but i've got nothing.
i want excel read in cell A2
let say in A2 = 09/11/2012 12:15:54 AM
so in C1 00:00-01:00
in C2, i want excel read in A2, from 00:00 - 01:00, the time interval is 45 minutes (because 12:15 until 01:00 is 45 minutes)

[FDibbins]

upload a sample workbook, sowing the data you have, your expected outcome, and how you arrived at that please

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[pan_arshad]

i dont know how to explain in words.
but the idea is something like this
for c3
if A3 > 10 AM & A3 < 11 AM and B3>10AM & B3<11AM then B3-A3
if A3 > 10 AM & A3 < 11 AM and B3>11 then 11 AM -A3
if A3 < 11 AM & B3>11AM then B3-10
else " "