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

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 ?

2 Replies

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

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

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

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 