+ Reply to Thread
Results 1 to 2 of 2

How do I summarize time that exceeds 24 hours?

  1. #1
    Rose
    Guest

    How do I summarize time that exceeds 24 hours?

    I am working on a diving log book and need to accumulate the total bottom
    time. Example: Accumulated bottom time from earlier dives 95:16, Time of this
    dive 00:40. Total acc time 95:56.

    How do I fill in the time 95:16? What cell format do I use?
    How do I summarize 95:16 with 00:40 and get 95:56? What function / cell
    format?



  2. #2
    Paul B
    Guest

    Re: How do I summarize time that exceeds 24 hours?

    Rose, format the cells as custom [h]:mm then just add the cells together

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Rose" <[email protected]> wrote in message
    news:[email protected]...
    > I am working on a diving log book and need to accumulate the total bottom
    > time. Example: Accumulated bottom time from earlier dives 95:16, Time of

    this
    > dive 00:40. Total acc time 95:56.
    >
    > How do I fill in the time 95:16? What cell format do I use?
    > How do I summarize 95:16 with 00:40 and get 95:56? What function / cell
    > format?
    >
    >




+ 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