Results 1 to 4 of 4

Time add of 24hrs+

Threaded View

  1. #1
    Forum Contributor pr4t3ek's Avatar
    Join Date
    10-13-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2003 & 2007, 2010
    Posts
    483

    Time add of 24hrs+

    Hi,

    I have the attached spreadsheet.

    All i'm trying to do is add time which is more than 24 hours to a date/time field and then give me a result.

    i.e. D2+C2 should equal 15/05/2013 12:00:00 AM for example (I believe)

    The formula works if the time is within 24 hours which you will see in row 3.

    Any help would be great.

    I'm in Australia so the date/time format of dd/mm/yyyy hh:mm:ss is perfect for me.

    Cheers
    Attached Files Attached Files
    Last edited by pr4t3ek; 12-30-2013 at 06:42 AM. Reason: Solved
    --
    Regards
    PD

    ----- Don't Forget -----

    1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks

    2. Thank those who have helped you by Clicking the scales above each post.

    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] negative time beyond 24hrs
    By SAsplin in forum Excel General
    Replies: 2
    Last Post: 05-10-2012, 07:57 AM
  2. Calculate time difference after 24hrs
    By PRodgers in forum Excel General
    Replies: 4
    Last Post: 07-16-2009, 08:24 AM
  3. Data Validation for dates & time exceeding 24hrs
    By Zyphon in forum Excel General
    Replies: 4
    Last Post: 08-30-2007, 04:37 AM
  4. [SOLVED] how to add time above 24hrs...
    By Bill R. in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-09-2005, 02:00 PM
  5. Time Calc - 24hrs vs 0hrs
    By Ltat42a in forum Excel General
    Replies: 9
    Last Post: 10-19-2005, 05: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1