Time duration calculation
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 |
Time duration calculation
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 |
Time duration calculation
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 |
Time duration calculation
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 |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com