| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula For Time Duration Calculation | Excel Discussion (Misc queries) | |||
| Time Duration Calculation help needed | Excel Discussion (Misc queries) | |||
| Need help with calculation - Duration or Time multiplied by cost | Excel Worksheet Functions | |||
| Excel calculation of duration in hours and minutes | Excel Worksheet Functions | |||
| Fixed Duration-strange calculation | New Users to Excel | |||
Threaded Mode
