hours and decimal help please

[idontknowitall]

Hello,

I am making a basic clocking in sheet for where I work,
So far I have it so I enter the employers time of clock in as 8:00 AM and then their lunch times and clock out time, I then have a columb for total hours and then the total hours in decimals, then I have a total weekly hours which it adds together the total hours in units but i cannot get it to do the same with the hours. I have tried a few different ways,

This is what I have at the moment

=TIME(INT(G8),MOD(G8,1)*100,0)
but it doesnt work

[Pete_UK]

To convert total hours into decimal hours you can do this:

=total_hours * 24

as Excel stores times internally as fractions of a 24-hour day.

Hope this helps.

Pete