The instruction say to press something, what am I suppose to be press in order to get this formula to work?
To apply Array formula:
Select the cell, press and simultaneously press .
The instruction say to press something, what am I suppose to be press in order to get this formula to work?
To apply Array formula:
Select the cell, press and simultaneously press .
The instruction say to press something, what am I suppose to be press in order to get this formula to work?
To apply Array formula:
Select the cell, press and simultaneously press .
Problem:
Columns A & B contain numbers representing hours and minutes respectively.
We want to add the numbers from both columns to calculate a single cumulative time value.
Solution:
Use the SUM and TIME functions as shown in the following Array formula:
{=SUM(TIME(A2:A4,B2:B4,0))}
To apply Array formula:
Select the cell, press
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks