| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate diffrence in dates in days and Hours
Hi,
I am working on data sheet and having to columns like Must be Solve Date and Actual Solve date i want to find diffrence between these 2 in days:hrs:mints in result column. sample i have provided below. can some one help me what formula can bring be exact diffrence in days:hrs:mints in Excel 2007 Must be reacted WasReacted Delay in Reaction 5/10/2010 6:05 5/10/2010 4:17 5/10/2010 7:43 5/10/2010 5:50 5/10/2010 9:22 5/10/2010 7:24 5/10/2010 10:30 5/10/2010 8:38 5/10/2010 11:10 5/10/2010 9:19 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate the the diffrence between 2 Dates and time | Excel Worksheet Functions | |||
| How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
| How do I calculate the week day hours between 2 days | Excel Discussion (Misc queries) | |||
| How to calculate days:Hours:Minutes: | Excel Worksheet Functions | |||
| How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
Threaded Mode
