Forum Discussion
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 | ? |
Thanks in advance for your replies.
2 Replies
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
- What result do you get when you use =B2-A2 formula? Isn't that your result?
