Results 1 to 11 of 11
  1. #1
    Newbie
    Join Date
    November 14th, 2011
    Posts
    5
    How to delete within a cell
    My boss handed me a 2000 tab report of data that looks like this:
    Wednesday 10/5/2011
    12:10 AM Armed 1352 -CA cityname, MBS 2
    12:29 AM Disarmed 1352 -CA cityname, MBS 2
    2:39 AM Disarmed 1352 -CA cityname, MBS 2
    3:40 AM Armed 1352 -CA cityname, MBS 2

    All in one cell, the next cell down has a different date. He has given me 1 day to format the data to say:
    time in: 12:10 AM
    Time out: 12:29 AM
    and to subtract time out from time in.

    Any suggestions? I need a way to do this quickly.

  2. #2
    OPM and Moderator Chuck Hamrick's Avatar
    Join Date
    April 5th, 2005
    Location
    Park City Utah
    Posts
    16,646
    Copy and past, better get to work!

  3. #3
    Newbie
    Join Date
    November 14th, 2011
    Posts
    5
    excel
    I've been doing that since 4am. Really no idea on how to make it easier?

  4. #4
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Interesting, are you a merchant?

    Try searching:

    split data into new cells using excel - Bing
    Salty kisses, Sandy toes, and a Pirate's heart...

  5. #5
    Newbie
    Join Date
    November 14th, 2011
    Posts
    5
    excel
    No.
    This is to match the times the alarm was turned on and off to clock in time to the amount of hours paid, for a single employee for the entire time they worked for us.....

  6. #6
    Newbie
    Join Date
    November 14th, 2011
    Posts
    5
    Excel
    BTW my first instinct was to use split colum function but since I need to keep the PM and their is a space it hasn't happened. I found a formula to delete everything after the time now I need one to add
    Time in:
    Time out:
    before the times and to insert "=TEXT(B146-B145,"h:mm:ss")" after or you know whatever it is that im subtracting...
    you got to admit I'm a pretty decent secretary....even if they only pay me the minimum.
    Last edited by HelenA; November 14th, 2011 at 02:44 PM.

  7. #7
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Just curious why you're posting in a forum that is for Affiliate Marketing...
    Salty kisses, Sandy toes, and a Pirate's heart...

  8. #8
    Newbie
    Join Date
    November 14th, 2011
    Posts
    5
    Excel
    I googled excel forums and this came up with a thread from 2005 with some people asking questions about excel. Sorry. If I could delete the thread, I would.

  9. #9
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Is what it is.

    Tell your boss "Garbage in - Garbage out" and to get you better formatted data.

    Good luck!
    Salty kisses, Sandy toes, and a Pirate's heart...

  10. #10
    Affiliate Manager Vendzilla's Avatar
    Join Date
    October 25th, 2011
    Posts
    201
    some good ways to use notepad for that using a varibles Armed **** -CA and replace with what ever you want

    I would give you a link, but it would be pulled

  11. #11
    Affiliate Manager Vendzilla's Avatar
    Join Date
    October 25th, 2011
    Posts
    201
    google BATCH FILE COMMANDS That should get you to where you need to be

  12. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. What Cell Phone are you using?
    By MichaelColey in forum Virtual Family and Off-Topic
    Replies: 44
    Last Post: March 12th, 2007, 05:25 PM
  2. Delete merchants, delete accounts
    By perfectG in forum Commission Junction - CJ
    Replies: 0
    Last Post: March 20th, 2003, 01:59 AM
  3. Cell Phones?
    By Freebie Hawk in forum Midnight Cafe'
    Replies: 1
    Last Post: November 4th, 2002, 12:00 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •