Perhaps this site can point you in the right direction:
http://www.cpearson.com/excel/datetime.htm tj "Stevem" wrote: I'm trying to calculate the time an employee has been with the company broken into years, months, and days. ie... cell A contains the employee's name , cell B contains their date of hire, cell C contains the current date , and cell D should contain the elapsed time. problem is that the dozens of formulas I've tried don't completely do the job. |
simple formula help
I'm trying to calculate the time an employee has been with the company
broken into years, months, and days. ie... cell A contains the employee's name , cell B contains their date of hire, cell C contains the current date , and cell D should contain the elapsed time. problem is that the dozens of formulas I've tried don't completely do the job. |
All times are GMT +1. The time now is 09:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com