How to do calculation when using TIME in formulas

[helpmeplease2018]

Hi,

I am working on a labor tracker for my restaurant and I am almost finished. But am struggling with totaling the hours worked as its all based on TIME.

Basically in AH8 (see attached) the total hours are correct if someone works a full week. But I would like it to do the calculation even if they only work one day.
The issue is because I have to multiply by 24 to get the correct hours worked, it continues doing the formula even if someone hasn't worked or they only worked one day. So when someone has worked 1 shift or no shifts that week it still does a calculation.

How do I fix this?

Thanks!
Mateusz

[JieJenn]

If you want to totaling just the hour, in Excel, there is a function called HOUR() that convert time to hour. In AG8, you can replace your formula with =SUM(HOUR(G8),HOUR(K8),HOUR(O8),HOUR(S8),HOUR(W8),HOUR(AA8),HOUR(AE8)) and that should fix the issue.

[helpmeplease2018]

thanks!!! how do i send money..