Results 1 to 5 of 5

Time related to 24hr clock

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2009
    Location
    Norway
    MS-Off Ver
    Excel 2003
    Posts
    3

    Thumbs up Time related to 24hr clock

    Hi all,
    I am a new user of this forum and this is my first post here
    I have a problem concerning having the excel to operate with 24hr times.
    What i try to achieve is:
    from 00:00hrs to 24:00hrs = 24hrs which is 1.0 day
    Have made the attached spredsheet to calculate it correctly to 1 day.
    But if you look on the attachment the "total hrs" is saying 00:00 (it transfers to 00:00 when i am putting in 24:00)
    Basically how am I able to make Excel to display 24:00 insted of 00:00

    Maybe there is an add ins availible like the pop up calendar but for times instead.

    Any help much appreciated.
    Stig
    Attached Files Attached Files
    Last edited by Stig; 06-22-2009 at 03:07 PM.

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