Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel General » [SOLVED] 2 cells with time to one cell

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-03-2009, 08:49 PM
Vanillajuice Vanillajuice is offline
Registered User
  
Join Date: 03 Jul 2009
Location: moore, ok, usa
MS Office Version:Excel 2003
Posts: 2
Vanillajuice is becoming part of the community
2 cells with time to one cell

Please Register to Remove these Ads

im trying to take 2 separate cells and combine the contents into one cell and put a dash or hyphen in between. like so

A1 = 8:00 AM
A2 = 5:00 PM

then have a formula to grab those 2 cells data and put them into one cell to look like this :

A3 = 8:00 AM - 5:00 PM

or

A3 = 8 - 5 <---this one would be best...if possible.

right now for the i have one cell getting the A1 data and another getting the A2 data.... with this formula :
=IF('CREATE SCHEDULE'!A1="","OFF",'CREATE SCHEDULE'!A1)

its set up to leave a blank if there is no timeslot...any help?
Last edited by Vanillajuice; 07-03-2009 at 11:15 PM.
Reply With Quote
  #2  
Old 07-03-2009, 10:16 PM
JBeaucaire's Avatar
JBeaucaire JBeaucaire is offline
Forum Guru
  
Join Date: 21 Mar 2008
Location: Bakersfield, CA
MS Office Version:2003 (can read 2007 files)
Posts: 9,483
JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay
Send a message via Skype™ to JBeaucaire
Re: 2 cells with time to one cell
Maybe something like this:

=IF(A1="","OFF",TEXT(A1,"H:MM AM/PM") & " - " & TEXT(A2,"H:MM AM/PM"))
__________________
If you've been given good help, use the icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Reply With Quote
  #3  
Old 07-03-2009, 10:24 PM
Vanillajuice Vanillajuice is offline
Registered User
  
Join Date: 03 Jul 2009
Location: moore, ok, usa
MS Office Version:Excel 2003
Posts: 2
Vanillajuice is becoming part of the community
Re: 2 cells with time to one cell
perfect! thanks!
Last edited by Vanillajuice; 07-03-2009 at 10:43 PM.
Reply With Quote
  #4  
Old 07-03-2009, 10:54 PM
JBeaucaire's Avatar
JBeaucaire JBeaucaire is offline
Forum Guru
  
Join Date: 21 Mar 2008
Location: Bakersfield, CA
MS Office Version:2003 (can read 2007 files)
Posts: 9,483
JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay JBeaucaire makes giving solutions look like childsplay
Send a message via Skype™ to JBeaucaire
Re: 2 cells with time to one cell
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
__________________
If you've been given good help, use the icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top