Forum Discussion
Solved
Multiply Hours and Minutes by a number
I have setup a spreadsheet to monitor my staff's holiday hours. I have formatted the cells using [h]:mm and also used the 1904 date system. My problem is that, when trying to multiply the hours by ...
TIME() function requires all 3 parameters, you can't miss seconds. Please check TIME function - Office Support (microsoft.com)
Barry, formulas looks correct, I'd only not to hardcode constants like TIME(10,46,0) and keep then in separate cells somewhere outside. Otherwise you need to correct every formula if the constant changes.
Sure, everything in Excel could be done by few different ways. Stay on formulas you are more familiar with if they give correct results.
| Shift Start | Shift End | Shift hours | Crew Size | Total hours | ||
| 9:00 AM | 5:00 PM | 8 | 10 | |||
| 8:00 AM | 5:00 PM | 9 | 12 | |||
Hey Sergei,
I need your help to format this excel sheet to calculate the total hours for each day for my cleaning business. I really appreciate your help so much with this.
Thanks
Bishoy Zaky