+ Reply to Thread
Results 1 to 3 of 3

correct current function

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    correct current function

    Hi everyone
    i need to add number of hour to current time and date i enter in A2,B2 (which combined in C2) and the result will be in E2 As combined between date and time
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: correct current function

    Change formula in C2

    =A2+B2

    Format as dd/mm/yyyy hh:mm

  3. #3
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: correct current function

    thanks JohnTopley for your effot
    i found also this work good ,
    =C2+D2/24

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 10-01-2016, 11:55 PM
  2. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  3. Replies: 4
    Last Post: 05-02-2014, 08:00 AM
  4. [SOLVED] Select the correct folder for the current month
    By jksung5295 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2013, 04:11 PM
  5. correct function to find a correct time value
    By jekidi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-06-2013, 03:17 PM
  6. Replies: 1
    Last Post: 08-13-2012, 11:18 AM
  7. adding current date then after saving the file current date function stops
    By gotbitey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 02:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1