Forum Discussion
InfoInquireLearn
Jan 09, 2025Copper Contributor
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.