Results 1 to 2 of 2

Thread: Convert Hours and Minutes From Separate Columns Into Time

  1. #1
    Junior Member
    Join Date
    Aug 2016
    Posts
    1
    Rep Power
    0

    Convert Hours and Minutes From Separate Columns Into Time

    Hello,

    I'm working with data (in the primary worksheet) that has the hours in one column and the minutes in the next column, for example 12 in the hours column and 10 in the minutes column refers to 12:10. I want to create a macro to fill in a table on the second worksheet and display as 12:10 in one cell. Can you help me with this?

    Thanks, Manu

  2. #2
    Junior Member
    Join Date
    Dec 2013
    Posts
    2
    Rep Power
    0
    suppose that your hour is in cell C1 and Minute in B1
    type this formula (with format cell as h:mm AM/PM)
    HTML Code:
    =TIME(C1,0,0)+TIME(,B1,0)

Similar Threads

  1. Replies: 3
    Last Post: 07-09-2014, 08:08 AM
  2. Formula To Round Date Time To Decimal Minutes
    By mrprofit in forum Excel Help
    Replies: 1
    Last Post: 04-22-2014, 07:57 PM
  3. Replies: 3
    Last Post: 02-24-2014, 05:48 AM
  4. Convert 24 hours to 48 hours in excel
    By dhiraj.ch185 in forum Excel Help
    Replies: 2
    Last Post: 11-15-2011, 09:02 AM
  5. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 AM

Posting Permissions

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