I am currently looking for a little help with Google Sheets.
I currently have three columns, B 'DATE' - C 'TIME' - D 'Dropdown list - BUY, Sell, Proforma'
So far, I have managed to do what I needed, but I am stuck on the last bit.
I have B set, that if D has any text, it enters the current date for me -
=IF(ISTEXT(D56); NOW(); "")
I have C set, that if D has any text, it shows the current time -
=IF(ISTEXT(D56); NOW(); "hh;mm")
My problem is this, if I leave column D empty, column C shows 'hh:mm' literally, the letters. If column D is left blank, how can I get column C to remain blank?