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.
Maybe something like this:
=IF(A1="","OFF",TEXT(A1,"H:MM AM/PM") & " - " & TEXT(A2,"H:MM AM/PM"))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
perfect! thanks!
Last edited by Vanillajuice; 07-03-2009 at 10:43 PM.
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)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks