+ Reply to Thread
Results 1 to 13 of 13

Making Time roll over after 24 hours

Hybrid View

  1. #1
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Making Time roll over after 24 hours

    Hi,

    Attached is a sample ...

    HTH
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-25-2009
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Making Time roll over after 24 hours

    here's what i have...

    note the time should read 06:42. My goal is to have it read "1 - hh:mm" if greater than 24 hours. When I change the blue cells (A1 & A2), it just rolls over without the day.
    Attached Files Attached Files
    Last edited by Emil240; 11-26-2009 at 03:10 AM. Reason: updated for clarity

  3. #3
    Registered User
    Join Date
    11-25-2009
    Location
    Illinois
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Making Time roll over after 24 hours

    To be more specific, when I attempted the format suggested it also alters the time to "0 - 12:42". So not only is it not rolling over, it is also displaying the incorrect time.

    Here is my most recent example.

    Thanks in Advance,
    Siv
    Attached Files Attached Files
    Last edited by Emil240; 11-26-2009 at 03:23 AM. Reason: to be more specific

+ 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