Calculating Hours Worked for the Week

%3CLINGO-SUB%20id%3D%22lingo-sub-323301%22%20slang%3D%22en-US%22%3ECalculating%20Hours%20Worked%20for%20the%20Week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323301%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wish%20to%20calculate%20a%20time%20sheet%20with%20employee%20hours.%26nbsp%3B%20The%20hours%20%26amp%3B%20formula%20column%20is%20custom%20-%20time%20format.%20My%20formula%20to%20add%20the%20hours%20worked%20in%20a%20week%26nbsp%3B%20works%20if%20the%20employee%20works%20under%2024%20hours.%20Any%20more%20hours%20it%20doesn't%20calculate%20correctly.%26nbsp%3B%20Can%20someone%20give%20me%20the%20correct%20formula%20or%20cell%20format%20to%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-323301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-323436%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20Hours%20Worked%20for%20the%20Week%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F269681%22%20target%3D%22_blank%22%3E%40TINT2019%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20would%20display%20the%20cell%20as%20a%20decimal%20number%20and%20multiple%20the%20values%20by%2024%20to%20convert%20into%20total%20hours%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Esee%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I wish to calculate a time sheet with employee hours.  The hours & formula column is custom - time format. My formula to add the hours worked in a week  works if the employee works under 24 hours. Any more hours it doesn't calculate correctly.  Can someone give me the correct formula or cell format to use?

 

1 Reply
Highlighted

Hi @TINT2019

 

I would display the cell as a decimal number and multiple the values by 24 to convert into total hours

 

see attached