How to connect value of cell and text
Hi
My father in law asked my to help him with Excel.
Usually I can handle everything on my own but this time I don't know what to do.
What he want is, if his employee came to work for example on 7:00, he want to put this number into a cell and then in this same celll should appear something like this
7-15 because he started on 7, he's working 8 hours, so 7+8 is 15.
To explain it better I will show you how I would do it in C#
int B2=7
string text=(B2 +"-"+(B2+8))
Unfortunately I see two major problems.
1. I don't know is this possible to write a function which changing value of this same cell in which it is written?
2. I do not know how to connect value of cell then put a text and then again value.
I don't know why it has to be this way, but he want it like this. And second thing is now I am curious how to solve this.
|