Using Decimal Time to work out Hours Worked from Start and Finish Times

[LowndesJ515]

Hi All,

I'm having trouble attempting to figure our Hours worked from a Start Time and Finish Time Cell. I can't use the normal hh:mm formula, needs to be in 00.00 format. Below is what i'm attempting to figure out. I've seen it being used in INT formula but i cant figure it out.

Time Start	Time Finish	Total Hours Worked
10.50	17.51	? Formula to work out Hrs Worked
06.50	15.12	?
14.42	19.35	?
06.01	11.32	?
14.42	19.55	?
05.41	11.32	?
10.50	18.59	?

Thanks in advance for your replies.

[#2]

What result do you get when you use =B2-A2 formula? Isn't that your result?

[#3]

@LowndesJ515 

Cell C3

=TIME(LEFT(B3,2),RIGHT(B3,2),)-TIME(LEFT(A3,2),RIGHT(A3,2),)

Since the times are left adjusted I assume they are text. 

NB - my local setting are h:mm (with colon) and 0,00 with comma as decimal character.

Col C number format = [h]:mm or h:mm (colon or period depending on local settings. [h] would show hours also over 24).

If col A is left adjusted, then it should work to subtract as @Harun24HR writes. If you want the hours with decimals, multiply by 24 (hours/day) and format as 0,00