Date and time in numbers
I want to type the time in a cel and that this cel ads the date from another cel, without changing the date to the current date
Question marked as
Best reply
Hi René,
Numbers is very good at detecting anything that looks like a Date & Time.
The trick is to enter the Date (Column A) and the Time (Column B) as Text.
Either format Columns A and B as Text, or type an apostrophe (') before the entry to "force" Text format.
Formula in C2:
A2&" "&B2
That will create a text string, but Numbers will recognise it as Date & Time. You can use Column C in calculations.
Test in Column D by adding 1 hour.
Formula in D2:
C2+"1h"
Test in Column E by adding 1 day.
Formula in E2:
C2+"1d"
Regards,
Ian.