Excel Tarih Birleştirme- Soru
-
Tarih-1(A) Tarih-2(B) Tarih-3(C) 4/6/2023 14:50 4/6/2023 14:50 =DATE(YEAR(A2);MONTH(A2);DAY(A2))+TIME(HOUR(B2);MINUTE(B2);SECOND(B2))
Cell Format -> Custom
Tarih-1(A) | Tarih-2(B) | Tarih-3(C) |
4/6/2023 | 14:50 | 4/6/2023 14:50 |
=DATE(YEAR(A2);MONTH(A2);DAY(A2))+TIME(HOUR(B2);MINUTE(B2);SECOND(B2))
Cell Format -> Custom