12 Replies Latest reply: Oct 9, 2007 3:38 AM by KOENIG Yvan
Level 1 (0 points)
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
• Level 4 (3,535 points)
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
• Level 8 (41,790 points)
Hello

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)
• Level 6 (15,825 points)
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:

• Level 2 (150 points)
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
• Level 1 (0 points)
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.

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

E4 with the modified code would give an answer of 9:00 willingly
• Level 6 (15,825 points)
I believe Numbers needs parenthesis placed for the date & time values to calculate properly.

Regards,
• Level 1 (0 points)
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.
• Level 1 (45 points)
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.

Did this really seem a cogent argument?
Wow.
• Level 8 (41,790 points)
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)
• Level 2 (150 points)
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
• Level 2 (150 points)
Hi,

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

~ Markus
• Level 8 (41,790 points)
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)