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
Top-ranking 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.