ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Earliest date & time (https://www.excelbanter.com/excel-programming/452480-re-earliest-date-time.html)

GARYWC

Earliest date & time
 
The dates and times are still in A1/B1 and in C1/D1 and the serial number is in E1.

Which date and time does the serial number represent?

isabelle

Earliest date & time
 
=IF(E1=A1+B1,ADDRESS(ROW(),1,4)&":"&ADDRESS(ROW(), 2,4),IF(E1=C1+D1,ADDRESS(ROW(),3,4)&":"&ADDRESS(RO W(),4,4),""))

isabelle

Le 2016-10-26 Ã* 19:54, GARYWC a écrit :
The dates and times are still in A1/B1 and in C1/D1 and the serial number is in E1.

Which date and time does the serial number represent?


Xuân76385

Lắp đặt, dÃ*n dá»±ng sân khấu chuyên nghiệp -LH 0911 000 222


Äạt Phương - ÄÆ¡n vị chuyên cung cấp, cho thuê âm thanh - ánh sáng - cung cấp, lắp đặt sân khấu phục vụ sá»± kiện chuyên nghiệp. ... Chuyên thiết kế, cung cấp vÃ* lắp đặt hệ thống thiết bị âm thanh, ánh sáng, không gian, ...sân khấu. Liên hệ Mr Äạt 0907 150 220



[center]









All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com