Time duration calculation

  • Thread starter Thread starter Deen
  • Start date Start date
D

Deen

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.
 
Hi Mike

Thanks for your reply, Is working great




Mike H said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
Hi Mike

Thanks for your reply, Is working great




Mike H said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top