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
=C22*MMULT( IFERROR(TEXTSPLIT(Y22, ":") + 0, 0), VSTACK(1 / 24, 1 / 24 / 60) )
Where C22=35
Y22=:45
Where C22=35
Y22=:45