Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 03-02-2019, 06:48 AM
bosco_yip bosco_yip is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2019
Location: Singapore
Posts: 7
bosco_yip is on a distinguished road
Default

Try,

In A1, enter 7:00

In B1, enter formula :

=A1*24&"-"&A1*24+8

Regards
Bosco
Reply With Quote
  #3  
Old 03-02-2019, 06:56 AM
Nortalf Nortalf is offline Windows 10 Office 2019
Novice
 
Join Date: Mar 2019
Posts: 2
Nortalf is on a distinguished road
Default

Great that's working, thanks.
Reply With Quote
Reply

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


All times are GMT -7. The time now is 07:25 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft