Calculating time frames

[Janus46]

Hello! I am a beginner/intermediate user of Excel. I am in HR and track all stages of the pre-employment process. I need to show quantitative data - for example - the number of days it took from the time we extended an offer to the time we were able to onboard that person.

Final Candidate

Position

Date Onboarding Email Sent

File Created

Date Background Check Entered

Date Background Check Completed

DT/Physical Requested

Date Cleared By

Onboarding Docs

Tentative Start Date

Actual Start Date

John Smith	Truck Driver	2/23/2024	x	3/11/2024	3/15/2024	3/14/2024	3/20/2024	x	04/01/24	4/8/2024​
Jayne Smith	Truck Driver	5/3/2024	x	3/4/2024	4/4/2024	4/5/2024	3/20/2024	x	3/25/2024	3/26/2024
Robert Smith	Truck Driver	3/18/2024	x	3/18/2024	3/21/2024	3/18/2024	4/2/2024​	x	4/14/2024	4/8/2024​
Shawn Smith	Truck Driver	4/5/2024	x	4/4/2024	4/9/2024	4/5/2024	3/20/2024	x	04/22/2024​	4/19/2024
Jeanne Smith	Truck Driver	4/5/2024	x	4/5/2024	4/12/2024	4/8/2024	4/5/2024	x	04/22/2024​	4/19/2024
John Smith	Truck Driver	4/9/2024	x	4/9/2024​	4/10/2024​	4/9/2024​	4/9/2024​	x​	04/22/2024​	4/19/2024

 

[awoohaw]

What quantitative measures do you want? Also, I think the file created date for Jayne Smith has the month and day number in the wrong order. Please confirm.

 

[myall_blues]

If all you want is the number of elapsed days between two dates you can just subtract one from the other. For example:

Book1
	A	B	C	D
1	Name	File created	Actual start date	Elapsed days
2	John Smith	23/02/2024	8/04/2024	45
3
Sheet1

Cell Formulas
Range	Formula
D2	D2	=C2-B2

@awoohaw as an Australian the date for Jane Smith is one of the few that looks the right way round to me.