Forum Discussion

InfoInquireLearn's avatar
InfoInquireLearn
Copper Contributor
Jan 09, 2025

Help in schedule-making

I am trying to add multiple times to create a total of hours for the week, but I can only seem to add a maximum of two days. 

I entered the formula to add the hours worked each day, but when I add those hours to make a total at the end of the week, it just pops up as eight, not thirty-two.

Any help would be great.

 

 

  • Select the cell(s) with the total, and apply the custom number format [h]:mm to them.

    The [ ] around h instruct Excel to display the time as duration instead of clock time.

Resources