+ Reply to Thread
Results 1 to 3 of 3

how to combine date and time in a cell

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    ismilia,egypt
    MS-Off Ver
    Excel 2007
    Posts
    1

    how to combine date and time in a cell

    i want to creat a sheet doing the following
    enter the phone numer in cell a1
    enter the phone break down hour in cell a2
    enter the phone break down date in cell a3
    combine the cell a2 & cell a3 in cell a 4
    enter the phone fixed hour in cell a5
    enter the cell fixed date in cell a6
    combine the a5&a6 in cell a7
    subtract a7-a4 and show the result in hours
    thank you
    Attached Files Attached Files
    Last edited by abimostafa920; 02-25-2013 at 06:38 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: how to solve the problem

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    10-22-2012
    Location
    hyd
    MS-Off Ver
    2010
    Posts
    159

    Re: how to solve the problem

    Hi,

    As per our forum rules please change the title of the thread.

    please explain us what do you want exactly. I didn't understand your query what it is?
    attaching a sheet is not enough to answer your thread.

    Regards,
    PRB.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1