Forum Discussion
InfoInquireLearn
Jan 08, 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 t...
HansVogelaar
Jan 09, 2025MVP
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.