Closed Thread
Results 1 to 3 of 3

Add another 24 hours to a time value

  1. #1
    Registered User
    Join Date
    07-17-2019
    Location
    Sweden
    MS-Off Ver
    Version 1906 MS Excel
    Posts
    34

    Add another 24 hours to a time value

    Hi! I wonder if it's possible to add 24 hours to a time value so Excel understands that it's the day after. If I just add 1 to 02:00 for example, the result is just 02:00 but it doesn't understand that it's actually one day after it (I'm doing this to compare two time values and when you compare for example 02:00 with 23:00 Excel think 23:00 is the higher value). Do you have to have dates involved for this?

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Add another 24 hours to a time value

    Adding 1 does make it into the next day, you just might not see it depending on the formatting of the cell.

    Generally speaking, it is a good idea to include dates with times.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,856

    Re: Add another 24 hours to a time value

    Administrative Note:

    Nice try, but it's still the same query ...

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...-midnight.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours
    By noobface in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-21-2021, 03:45 AM
  2. Replies: 3
    Last Post: 07-24-2018, 03:24 AM
  3. [SOLVED] Count Hours between Start Time & End Time but exclude Break Hours
    By josephteh in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2017, 10:44 AM
  4. Replies: 5
    Last Post: 04-13-2017, 11:05 AM
  5. Replies: 2
    Last Post: 11-12-2014, 11:56 AM
  6. [SOLVED] Adding hours to start time - Business hours/holidays/weekends
    By Thunderer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 01:09 PM
  7. [SOLVED] Formula to Calculate Normal Hours, Time & 1/2 & Double Time from Daily Hours per week
    By KazzICC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2014, 01:51 AM

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