Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM 15:00

See herewith i required the result like need to calculate time duration B-A,
Any one can help me on this.

Thanks in advance
Ahamed

Deen

Use the formula

=B2-A2

Format the formula cell with a Custom format of [h]:mm

Drag down
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Deen" wrote:

Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM 15:00

See herewith i required the result like need to calculate time duration B-A,
Any one can help me on this.

Thanks in advance
Ahamed

Hi Mike

Thanks for your reply, Is working great




"Mike H" wrote:

Deen

Use the formula

=B2-A2

Format the formula cell with a Custom format of [h]:mm

Drag down
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Deen" wrote:

Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM 15:00

See herewith i required the result like need to calculate time duration B-A,
Any one can help me on this.

Thanks in advance
Ahamed

Hi Mike,

I hope you all are doing well, I required your help to resolve my issue in
excel.

On single worksheet i have two different sheet name as 1.IP Range 2. Result.

Question:
EG:IP Range

Start IP End IP
Area

192.168.1.4 195.182.254.254 AG
10.15.33.10 10.18.56.254
EMEA
10.128.33.5 10.132.40.60 AP

Here it will Continued as well.

On Result sheet i required result like:

IP Area

192.170.30.30 AG
194.168.10.20 AG
10.131.37.20 EMEA
10.170.255.255 NA
10.129.36.8 AP

I required result on area column. Here we have more than 50000 IP's but very
difficult to find the area.

Could any one please help me on this issue. How i can resolve the issue


Thanks in advance
Deen






"Deen" wrote:

Hi Mike

Thanks for your reply, Is working great




"Mike H" wrote:

Deen

Use the formula

=B2-A2

Format the formula cell with a Custom format of [h]:mm

Drag down
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Deen" wrote:

Hi Team,
A B
C
REPORTEDDATETIME STATUSDATE Result (HH:MM)
03/16/2009 07:00 AM 03/16/2010 07:00 AM 8760:00
02/16/2010 04:00 AM 02/16/2010 07:00 PM 15:00

See herewith i required the result like need to calculate time duration B-A,
Any one can help me on this.

Thanks in advance
Ahamed