+ Reply to Thread
Results 1 to 4 of 4

Adding hh:mm to a time to get a new time

  1. #1
    Forum Contributor
    Join Date
    10-12-2018
    Location
    Leesburg, FL
    MS-Off Ver
    2013
    Posts
    112

    Adding hh:mm to a time to get a new time

    If I have a time like 4:35 am and I want to add 15h 22min to it to get 7:57 pm, how can I do this?

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,263

    Re: Adding hh:mm to a time to get a new time

    With your first time in A1, use this where you want the new time:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If you have the hours/mins in other cells, you could use the cell refs directly in the formula, something like this (hours in B1, mins in C1):
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Regards,
    Aardigspook

    My internet connection can be intermittent, so sometimes I may not reply quickly to questions. Sorry - it's not personal and I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    10-12-2018
    Location
    Leesburg, FL
    MS-Off Ver
    2013
    Posts
    112

    Re: Adding hh:mm to a time to get a new time

    Thank you! That's exactly what I was looking for.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily NL, sometimes UK
    MS-Off Ver
    2010
    Posts
    2,263

    Re: Adding hh:mm to a time to get a new time

    You're welcome, glad I could help and thanks for the rep.

+ 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