+ Reply to Thread
Results 1 to 4 of 4

Formula to add minutes to a timestamp

  1. #1
    Registered User
    Join Date
    11-28-2015
    Location
    Chilliwack, BC
    MS-Off Ver
    Office 365
    Posts
    39

    Formula to add minutes to a timestamp

    Hello I have cell A1 with a time stamp (12:05:39). Cell B1 has a number 3.9. I would like C1 to be - (B1) 3.9 minutes added to the cell A1 timestamp.
    Thanks in advance!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,718

    Re: Formula to add minutes to a timestamp

    Try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-28-2015
    Location
    Chilliwack, BC
    MS-Off Ver
    Office 365
    Posts
    39

    Re: Formula to add minutes to a timestamp

    Thats the answer. Thanks for the help @6StringJazzer

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,718

    Re: Formula to add minutes to a timestamp

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

    If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

+ 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: 2
    Last Post: 11-09-2016, 02:23 PM
  2. Timestamp data entry and highlight when no data entered after 10 minutes
    By jdcarter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2015, 08:19 AM
  3. [SOLVED] Extracting Only the Minutes from Timestamp
    By fearonc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2014, 05:45 PM
  4. [SOLVED] Flooring timestamp to minutes mystery (Have solution that doesn't quite work)
    By gregersdk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-12-2014, 12:05 PM
  5. VBA Timestamp when value changes by formula
    By rgs694 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 01:16 PM
  6. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  7. Formula for minutes to days:hours:minutes
    By QueenCutieT in forum Excel General
    Replies: 3
    Last Post: 02-09-2005, 09:06 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