+ Reply to Thread
Results 1 to 2 of 2

Adding time

  1. #1
    trucker
    Guest

    Adding time

    I want to add time,like a sum.

    12:00+12:00+12:00=36:00?

    I keep getting a basic time like 12:00. Could you please supply a formula.

    Thank you


  2. #2
    Roger Govier
    Guest

    Re: Adding time

    Hi
    In the cell with the formula, Format>Cells>Number>Custom [h]:mm
    Putting the [ ] brackets around h allows it to sum past 24 hours.

    Regards

    Roger Govier


    trucker wrote:
    > I want to add time,like a sum.
    >
    > 12:00+12:00+12:00=36:00?
    >
    > I keep getting a basic time like 12:00. Could you please supply a formula.
    >
    > Thank you
    >


+ 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