I have 4 dates In this format dd/mm/yyyy,hh:mm. Date1, Date2, Date3 and Date 4
The formula is: =(Date1+Date2)-(Date3+Date4) the results must be in hh:mm
At the moment I have 3 columns,
- A =TEXT([Date1]+[Date2],"hh:mm")
- B =TEXT([Date3]+[Date2],"hh:mm")
- C =TEXT([A]-[B],"hh:mm")
I only need one column for this, I've tried putting it together and I get errors.
Thanks