#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Try,
In A1, enter 7:00 In B1, enter formula : =A1*24&"-"&A1*24+8 Regards Bosco |
#3
|
|||
|
|||
Great that's working, thanks.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change Text Colour in Cell Based on Text in Same Cell | PMC11 | Word VBA | 1 | 11-14-2017 09:15 PM |
extract time from a cell and move it to front of cell before text | ewso | Excel | 20 | 03-19-2017 11:34 AM |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
How to input the text of a cell into another cell automatically ? | Juliet | Excel | 1 | 03-15-2013 03:25 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |