+ Reply to Thread
Results 1 to 4 of 4

time manipulation: 13:20 + 2:40 =???

  1. #1
    Registered User
    Join Date
    06-09-2006
    Posts
    62

    time manipulation: 13:20 + 2:40 =???

    Hi all,

    here's a quick question that drives me crazy:
    Say I have the time in cell A1 as 13:20 And in cell A2 I would like to state 'number of hours" eg., 2:40, I would like to see the end result on cell A3 as:

    13:20
    +2:40
    --------
    16:00

    Does anyone have any idea how to do that?

    thank you!

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Well, exactly what you said =A1+A2 ...

    If need be, format A3 hh:mm ...

    HTH
    Carim

  3. #3
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    As carim replied


    Also If total time is greater than 24 hours and you want to see it displayed in hours and minutes custom format a3 as [h]:mm

  4. #4
    Registered User
    Join Date
    06-09-2006
    Posts
    62
    got it....the FORMAT!!!!
    thanks

+ 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