View Single Post
 
Old 03-02-2019, 06:13 AM
Nortalf Nortalf is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2019
Posts: 2
Nortalf is on a distinguished road
Default 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.
Reply With Quote