Age and Time Calculation In MS Excel

Age and Time Calculation in MS Excel

Step 1: First start excel, in run dialog box command is excel.
Step 2: Enter Two Dates

Step 3: Minus – two dates

Step 4: Right click on the cell

Click on  Number->Category->Custom->Type
.

Step 5: Enter formula (     yy “Years”, mm “Months”, dd “Days”    )

Step 6: Result

Step 7: Time Calculation

Step 8: Right Click on the cell

Step 9: Enter Formula  (      hh “Hours”, mm “Minutes”, ss “Seconds”     )

Result