How to divide time by numbers

[DblK]

I am trying to determine how long it takes a typist on average to type a page. I have added the minutes and seconds together and have a total of pages typed within that time frame. Now I am trying to divide the time spent typing by the amount of pages typed. I cannot determine the formula to use. Any ideas?

[FDibbins]

Hi, welcome to the forum

Time is really just a decimal of 1 (day), so 6:00 am is 0.25, 12 noon is 0.5 and 6:00 pm is 0.75. Based on that, all you need to do is run the calcs the same as you would for any other numbers - the ONLY difference being, you will need to change the formatting to General or Number (your chioce)

	A	B	C	D	E	F	G
1	Start	End	Pcs	Time	General	Pcs/time	Time/Pc
2	8:00	12:00	10	4:00	0.166667	60	0.016667
3				=B2-A2	=B2-A2	=C2/E2	=E2/C2

D2 is just as excel will give you the answer.
E2 is what that would look like after you format it as General