1117 Views 12 Replies Latest reply: Oct 9, 2007 3:38 AM by KOENIG Yvan
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:
to get the current display:
Yvan KOENIG (from FRANCE mercredi 12 septembre 2007 23:10:1)
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:
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
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.
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.
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?