+ Reply to Thread
Results 1 to 2 of 2

Any one know why roundup doesn't work with time?

  1. 01-15-2021, 02:02 AM #1
    Lostcar
    Lostcar is offline
    Registered User
    Join Date
    04-22-2020
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    21

    Any one know why roundup doesn't work with time?

    Anyone know why the yellow cells simply will not round up properly? I tried different cell format options but nothing seems to work.
    Ive tested them with with normal number cells (Green) and it works fine.
    Not sure whats going on here.

    Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-15-2021, 02:31 AM #2
    AliGW
    AliGW is offline
    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. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,886

    Re: Any one know why roundup doesn't work with time?

    Here's why:

    Excel 2016 (Windows) 32 bit
    C
    1
    1.00000000011642000
    Sheet: Sheet1

    Try this in C1:

    =ROUND((B1-A1)*24,0)
    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.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding a row below the active cell - doesn't always work first time
    By kissarmy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2017, 06:48 PM
  2. [SOLVED] Time Stamp doesn't work
    By opusarlo in forum Excel General
    Replies: 13
    Last Post: 01-06-2016, 05:29 PM
  3. Macro sometimes work, sometimes doesn't but works 100% of the time on another computer
    By mfk223 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-15-2014, 04:36 PM
  4. Repeating time periods - (when simple MOD doesn't work)
    By joeljoel in forum Excel General
    Replies: 3
    Last Post: 08-10-2011, 10:05 AM
  5. Why doesn't the DDB function work all the time?
    By Pileski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2006, 05:44 PM
  6. [SOLVED] Doesn't work all the time
    By Alex St-Pierre in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-30-2006, 05:45 PM
  7. Custom Time Format doesn't work for me
    By chuck in forum Excel General
    Replies: 1
    Last Post: 02-13-2005, 01:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1