Skip navigation
This discussion is archived

Adding dates & times

1071 Views 12 Replies Latest reply: Oct 9, 2007 3:38 AM by KOENIG Yvan RSS
ThomDennis Calculating status...
Currently Being Moderated
Sep 12, 2007 1:43 PM
Hi, In Excel it is simple to add dates or times (eg start time + duration = end time) but this doesn't work in numbers and I can't see a way round it. Am I missing something?
Thanks
MacBook Pro, Mac OS X (10.4.10), Numbers Version 1.0
  • jaxjason Level 4 Level 4 (3,320 points)
    Currently Being Moderated
    Sep 12, 2007 1:49 PM (in response to ThomDennis)
    search the forum for Date, I got almost 400 returned items (many of them are most likely responses to other posts, but it answers your question completely and in much more detail than one response can cover.

    Jason
    Power Mac Dual 2.0 G5, Mac OS X (10.4.10)
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Sep 12, 2007 2:24 PM (in response to ThomDennis)
    Hello

    Thisthread:
    <http://discussions.apple.com/thread.jspa?messageID=5311289&#5311289>
    treats widely of the question.

    I will shorten it.

    In Numbers we can't add date and times. It's a pity but we have to live with it for some months.
    Happily if the startig time is in B2 and duration is in C2 we may compute the ending time (in decimal representation) thru:
    D2 =(TIMEVALUE(B2)+TIMEVALUE(C2))*24
    to get the current display:

    E2 =INT(D24)&":"&RIGHT("00"&INT((D2-INT(D2))*60);2)


    Yvan KOENIG (from FRANCE mercredi 12 septembre 2007 23:10:1)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.10)
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Sep 12, 2007 6:05 PM (in response to ThomDennis)
    If you convert your time values into fractions of a 24 hour period (or fractions of a day), you can add times. 1 hour = 1/24, etc...

    Regards,

    Example Highlighted:

    Photo Sharing and Video Hosting at Photobucket
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.4.10), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • Markus Guske1 Calculating status...
    Currently Being Moderated
    Oct 8, 2007 2:04 AM (in response to ThomDennis)
    Hi,

    just adding two time values just works for me, but don't try it with subtracting a third value
    interestingly adding a third value just works - and also corrects the cell format ???? see below:

    <pre>
    A B C D E
    3 Start End Pause Hours given formula
    4 08:30 17:00 00:30 09:00 B3-A3+A4
    5 00:30 0,4 B3-A3 (strange format, D5 is set to HH:MM)
    6 Error B3-A3-C3
    </pre>

    I think, Apple has to "finish" the time-handling in Numbers.
    This is sad, because you need those handling e.g. for time-tracking sheets.

    ~ Markus
    PowerBook G4 17 2003, iMac 20" intel, Mac OS X (10.4.5), 2 GB RAM
  • lowededwookie Calculating status...
    Currently Being Moderated
    Oct 8, 2007 4:09 PM (in response to Markus Guske1)
    I think I found a problem with your formula.

    E4 reads: B3-A3+A4 and is also missing the "=" from the start of the formula.

    B3 reads: End
    A3 reads: Start

    I think E4 should read: =B4-A4+A5

    E4 with the modified code would give an answer of 9:00 willingly
    Intel Mac Mini 1.66Ghz, Mac OS X (10.4.10)
  • WWJD Level 6 Level 6 (15,815 points)
    Currently Being Moderated
    Oct 8, 2007 4:16 PM (in response to Markus Guske1)
    I believe Numbers needs parenthesis placed for the date & time values to calculate properly.

    Regards,
    MDD Dual 1GHz 2GB RAM / QS 867MHz 1.5GB RAM, Mac OS X (10.4.10), 2930 SCSI / 16x DVR-110D / Yamaha 01X / 1GB Shuffle x 2 / 4GB Nano :o)
  • nothtebeancounter Calculating status...
    Currently Being Moderated
    Oct 8, 2007 7:50 PM (in response to WWJD)
    handling dates and times is programming 101. it's not that hard. in fact we expect 10 year olds to master it. i fail to see why numbers can't. can we also have an insert date/time function please in the menu. i expect it to be fixed first update.a complete set of date functions including number of days, hours, minutes, seconds whatever for forward, backward analysis or calculations please.
    macbook, Mac OS X (10.4.10)
  • jimdoc Level 1 Level 1 (45 points)
    Currently Being Moderated
    Oct 8, 2007 8:10 PM (in response to nothtebeancounter)
    handling dates and times is programming 101.


    Then think of how much money you can make for yourself by doing it right!

    in fact we expect 10 year olds to master it.


    Ah, but Numbers isn't even 1 yet....

    i expect it to be fixed first update.


    Sorry, missed that one already.

    Did this really seem a cogent argument?
    Wow.
    MacBook Pro (01/06 version), Mac OS X (10.4.10)
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Oct 8, 2007 10:55 PM (in response to nothtebeancounter)
    Hello

    go to "Provide Numbers Feedback" in the "Numbers" menu and describe what you wish !

    Yvan KOENIG (from FRANCE mardi 9 octobre 2007 07:55:37)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.10)
  • Markus Guske1 Level 2 Level 2 (150 points)
    Currently Being Moderated
    Oct 9, 2007 1:16 AM (in response to lowededwookie)
    Hi,

    sorry, just forgot to copy the '='. The formula is correct.

    E4 is 09:00
    E6 is an error, only difference is the '-' instead of '+'

    ~ Markus
    PowerBook G4 17 2003, iMac 20" intel, Mac OS X (10.4.5), 2 GB RAM
  • Markus Guske1 Level 2 Level 2 (150 points)
    Currently Being Moderated
    Oct 9, 2007 1:17 AM (in response to KOENIG Yvan)
    Hi,

    of course, and I already did
    Hope we'll see an update soon.

    ~ Markus
    PowerBook G4 17 2003, iMac 20" intel, Mac OS X (10.4.5), 2 GB RAM
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Oct 9, 2007 3:38 AM (in response to Markus Guske1)
    Hello

    Your request is not a bug correction but a new feature, so my guess is that a responce will not be available before iwork'09.

    Yvan KOENIG (from FRANCE mardi 9 octobre 2007 12:37:52)
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.10)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.