Hi All
So I know on adding time formats in excel. However if I have one cell which is empty I still want to return the one cell which has the time in.
Example
A1 - 13:00 A2 - 5:00 so would equal - 18:00
However, if A2 is empty I still want it to return the A1 amount of 13:00
Wha would be the best if formula? thanks
So I know on adding time formats in excel. However if I have one cell which is empty I still want to return the one cell which has the time in.
Example
A1 - 13:00 A2 - 5:00 so would equal - 18:00
However, if A2 is empty I still want it to return the A1 amount of 13:00
Wha would be the best if formula? thanks