Calculating the difference between start and finish times in hours and minutes

[Katie152]

Hello,
I'm trying to create a rota which automatically calculates an employee's hours worked per day.
I would like to know how to calculate the difference between a1 (start time) and b1 (finish time) into c1 (hours worked)

Thank you

 

[etaf]

would this be in the same day - No start one day and finish the next day - Just time

If in time format
B1-A1

You can format [H]:MM to remove any leading zeros

Book2
	A	B	C
1	12:00	16:00	4:00
Sheet1

Cell Formulas
Range	Formula
C1	C1	=B1-A1

 

[Katie152]

Hi Etaf,
Thank you,Yes this is for start and finish times on the same day However, when the finish time is not a whole hour the value returned isn't quite right.
For example, 14:15 the value returned is 4.15, ideally i'd like it display 4.25
14:30 the value returned is 4.3, ideally i'd like it display 4.5
14:45 the value returned is 4.45, ideally i'd like it display 4.75

Is there any way to do this?

 

[alz]

How about this!
with time format
=(C1-B1)*24

 

[Dave Patton]

format the dates to your preference
- rounded up
- OK if hours span midnight

Date and Time 2021.xlsm
	B	C	D	E
2				$ 100.00
3	10:00	14:15	4.25	425.00
4	10:00	14:33	4.75	475.00
5	22:00	02:50	5.00	500.00
2d

Cell Formulas
Range	Formula
D3:D5	D3	=CEILING((C3-B3+(B3>C3))*24,0.25)
E3:E5	E3	=$E$2*D3

 

[Katie152]

Thank you all for your help, I have now managed to get the correct values. Methods from both Alz and Dave Patton worked great

 

[Dave Patton]

Thanks for the feedback.