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)
Okay, I have an error if it totals over 24 hours. It will just return anything over 24:00
:45 per unit x 35 units = 2:15
:45 per unit x 35 units = 2:15