+ Reply to Thread
Results 1 to 2 of 2

Adding elapsed time to date/time format over 24h

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Svalbard
    MS-Off Ver
    Excel 2003, 2010
    Posts
    1

    Adding elapsed time to date/time format over 24h

    Hello,

    I have a quick question. Seems like it should be very simple and common problem, but I couldn't find the answer elsewhere.

    My problem is that I have a dataset, where the elapsed time is in minutes. I also have a start time from which the elapsed time is calculated. I need to regroup this into a single column with the following format: 2010-08-26 11:08:57 (year-month-day hour-min.sec).

    To add the minutes I use the TIME(hour;min:sec) function. However, once the minutes exceed 1440 (1 day) Excel resets the minutes and only adds the value above 1440. I understand you can specify [min] in the format to add over a 24h period but in this case I would simply like to take this into account in the date.

    Do you have any suggestions?

    Many thanks in advance.

    Kim

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Adding elapsed time to date/time format over 24h

    Hello Kim, if start time/date is in A2 and minutes to add in B2 use this formula in C2 to get end time/date

    =A2+B2/1440

    format C2 in required date/time format
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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