Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time duration formula
I would like to know the formula to work out my employees employment
duration, from a given start date to the current day. many thanks |
#2
|
|||
|
|||
Take a look at DATEDIF. Explained at
http://www.cpearson.com/excel/datedif.htm -- HTH RP (remove nothere from the email address if mailing direct) "Ska" wrote in message ... I would like to know the formula to work out my employees employment duration, from a given start date to the current day. many thanks |
#3
|
|||
|
|||
Thanks Bob,
I have used the formula but have come across another small problem, i have an emplyee who has been with us twice so has one period and now an ongoing period of emplyment , what i would like to do is add both periods together to get the total duration worked with us. Hope you can help. Ta Stu "Bob Phillips" wrote: Take a look at DATEDIF. Explained at http://www.cpearson.com/excel/datedif.htm -- HTH RP (remove nothere from the email address if mailing direct) "Ska" wrote in message ... I would like to know the formula to work out my employees employment duration, from a given start date to the current day. many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time formula | Excel Discussion (Misc queries) | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
Time / Formula to look at time difference | Excel Worksheet Functions | |||
Excel Time Duration Formula | Excel Worksheet Functions |