Formula to lookup data based on a sum of two cells

[GoddardE]

Hi, this is my first post so I want to apologise in advance for my very basic knowledge of excel.
I have a spreadsheet that has been created by the company for overtime hours. On the main page there are two columns for the start time and end time of the overtime. They have a tab converting minutes into their decimal place value (I.e. 30 mins = 0.5). So if I have worked between 9.00 and 11.30 in the morning being 2 1/2hrs Currently I just need to use the table to work out the minutes value and type in the third column 2.5. But there must be a simple formula to work out the difference between column 1 and 2 and then lookup the minutes decimal value on the other tab. I would really appreciate any help without using macros as work will not accept those.

 

[Toadstool]

Hi GoddardE,

Excel holds a date as days since 1 Jan 1900 1904 for Mac) and time as fractions of a day. You can get the difference in decimal hours by multiplying the difference by 24. NOTE: The result must be formatted as a Number with your required decimal places.

Book1
	B	C	D
1	Start	End	Decimal Difference
2	9:00	11:30	2.50
3	8:00	9:00	1.00
4	9:00	18:45	9.75
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=(C2-B2)*24

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A	B	C
1
2	9.00	11.30	2.50
3	9.00	12.45	3.75
Main

Cell Formulas
Range	Formula
C2:C3	C2	=DOLLARDE(B2,60)-DOLLAR(A2,60)