+ Reply to Thread
Results 1 to 6 of 6

adaptation from one format to an other for me more suitable

  1. 09-05-2022, 11:14 AM #1
    Michel Davidts
    Michel Davidts is offline
    Registered User
    Join Date
    09-05-2022
    Location
    Brussels
    MS-Off Ver
    2207
    Posts
    3

    adaptation from one format to an other for me more suitable

    Hi
    I frequently have to adapt the format to a more suitable format.
    in column B you can find the datum + the time fixed on 23u:00. From kolom J en further every time a figure but 15 minutes later. This figues represent a consumption at a specific data and time.
    I only need the information when colum I = A+

    I would like to transform this to a date colum; a time colum (15minutes) and finaly the consumption figures of that specific date and time. of of this information vertical presented.

    thanks in advance
    Reply With QuoteRegister To Reply
  2. 09-05-2022, 11:22 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: adaptation from one format to an other for me more suitable

    There is no workbook attachet yet.

    Administrative Note:

    Members will tailor the solutions they offer to the version (NOT a release number like 2207) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 09-05-2022, 11:37 AM #3
    Michel Davidts
    Michel Davidts is offline
    Registered User
    Join Date
    09-05-2022
    Location
    Brussels
    MS-Off Ver
    2207
    Posts
    3

    Re: adaptation from one format to an other for me more suitable

    Hello Ali

    Do you mean 2021 MSO? Thanks and kind regards Michel
    Reply With QuoteRegister To Reply
  4. 09-05-2022, 11:48 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: adaptation from one format to an other for me more suitable

    Yes - that's correct. And please attach the workbook.
    Reply With QuoteRegister To Reply
  5. 09-05-2022, 12:02 PM #5
    Michel Davidts
    Michel Davidts is offline
    Registered User
    Join Date
    09-05-2022
    Location
    Brussels
    MS-Off Ver
    2207
    Posts
    3

    Re: adaptation from one format to an other for me more suitable

    Hello Ali

    I just added the file. I had to make it smaller. thanks and regards Michel
    Reply With QuoteRegister To Reply
  6. 09-06-2022, 08:27 PM #6
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: adaptation from one format to an other for me more suitable

    I don't see an Excel file in any of your three posts.
    Information on attaching an Excel file to your next post is provided in the "HOW TO ATTACH YOUR SAMPLE WORKBOOK" banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. reorganizing data from pivot table format to a format more suitable for presentations
    By [email protected] in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-12-2013, 01:41 PM
  2. Adaptation Hours using Combobox
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-07-2012, 02:48 PM
  3. Distance formula adaptation
    By aardvark23 in forum Excel General
    Replies: 13
    Last Post: 04-16-2010, 09:55 AM
  4. Adaptation of code to delete data
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2008, 06:59 PM
  5. If query adaptation
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2007, 07:12 AM
  6. Adaptation Of A Formula
    By Big Rick in forum Excel General
    Replies: 6
    Last Post: 09-30-2005, 01:05 PM
  7. Formula array adaptation
    By Ellie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2005, 12:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1