Microsoft 365 與 Office | Excel | 商用版 | Windows
一系列 Microsoft 試算表軟體，具有可用來對資料進行分析、製圖及通訊的工具
你可以用公式：
=WRAPROWS(SEQUENCE(365,1,DATE(2023,1,16)+10/24,1),7)
365是365天
Date(2023,1,16)是从这个日期开始
10/24，是每天10点。
单元格格式是
yyyy-mm-dd ddd hh:mm:ss
如何在Excel generate 特定格式日期時間? 如下圖, 類似月曆,有日期,星期幾,但時間不變,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
匿名
| 2023-01-16 Mon 10:00:00 | 2023-01-17 Tue 10:00:00 | 2023-01-18 Wed 10:00:00 | 2023-01-19 Thu 10:00:00 | 2023-01-20 Fri 10:00:00 | 2023-01-21 Sat 10:00:00 | 2023-01-22 Sun 10:00:00 |
|---|---|---|---|---|---|---|
| 2023-01-23 Mon 10:00:00 | 2023-01-24 Tue 10:00:00 | 2023-01-25 Wed 10:00:00 | 2023-01-26 Thu 10:00:00 | 2023-01-27 Fri 10:00:00 | 2023-01-28 Sat 10:00:00 | 2023-01-29 Sun 10:00:00 |
| 2023-01-30 Mon 10:00:00 | 2023-01-31 Tue 10:00:00 | 2023-02-01 Wed 10:00:00 | 2023-02-02 Thu 10:00:00 | 2023-02-03 Fri 10:00:00 | 2023-02-04 Sat 10:00:00 | 2023-02-05 Sun 10:00:00 |
| 2023-02-06 Mon 10:00:00 | 2023-02-07 Tue 10:00:00 | 2023-02-08 Wed 10:00:00 | 2023-02-09 Thu 10:00:00 | 2023-02-10 Fri 10:00:00 | 2023-02-11 Sat 10:00:00 | 2023-02-12 Sun 10:00:00 |
| 2023-02-13 Mon 10:00:00 | 2023-02-14 Tue 10:00:00 | 2023-02-15 Wed 10:00:00 | 2023-02-16 Thu 10:00:00 | 2023-02-17 Fri 10:00:00 | 2023-02-18 Sat 10:00:00 | 2023-02-19 Sun 10:00:00 |
| 2023-02-20 Mon 10:00:00 | 2023-02-21 Tue 10:00:00 | 2023-02-22 Wed 10:00:00 | 2023-02-23 Thu 10:00:00 | 2023-02-24 Fri 10:00:00 | 2023-02-25 Sat 10:00:00 | 2023-02-26 Sun 10:00:00 |
| 2023-02-27 Mon 10:00:00 | 2023-02-28 Tue 10:00:00 | 2023-03-01 Wed 10:00:00 | 2023-03-02 Thu 10:00:00 | 2023-03-03 Fri 10:00:00 | 2023-03-04 Sat 10:00:00 | 2023-03-05 Sun 10:00:00 |
| 2023-03-06 Mon 10:00:00 | 2023-03-07 Tue 10:00:00 | 2023-03-08 Wed 10:00:00 | 2023-03-09 Thu 10:00:00 | 2023-03-10 Fri 10:00:00 | 2023-03-11 Sat 10:00:00 | 2023-03-12 Sun 10:00:00 |
| 2023-03-13 Mon 10:00:00 | 2023-03-14 Tue 10:00:00 | 2023-03-15 Wed 10:00:00 | 2023-03-16 Thu 10:00:00 | 2023-03-17 Fri 10:00:00 | 2023-03-18 Sat 10:00:00 | 2023-03-19 Sun 10:00:00 |
| 2023-03-20 Mon 10:00:00 | 2023-03-21 Tue 10:00:00 | 2023-03-22 Wed 10:00:00 | 2023-03-23 Thu 10:00:00 | 2023-03-24 Fri 10:00:00 | 2023-03-25 Sat 10:00:00 | 2023-03-26 Sun 10:00:00 |
| 2023-03-27 Mon 10:00:00 | 2023-03-28 Tue 10:00:00 | 2023-03-29 Wed 10:00:00 | 2023-03-30 Thu 10:00:00 | 2023-03-31 Fri 10:00:00 | 2023-04-01 Sat 10:00:00 | 2023-04-02 Sun 10:00:00 |
| 2023-04-03 Mon 10:00:00 | 2023-04-04 Tue 10:00:00 | 2023-04-05 Wed 10:00:00 | 2023-04-06 Thu 10:00:00 | 2023-04-07 Fri 10:00:00 | 2023-04-08 Sat 10:00:00 | 2023-04-09 Sun 10:00:00 |
| 2023-04-10 Mon 10:00:00 | 2023-04-11 Tue 10:00:00 | 2023-04-12 Wed 10:00:00 | 2023-04-13 Thu 10:00:00 | 2023-04-14 Fri 10:00:00 | 2023-04-15 Sat 10:00:00 | 2023-04-16 Sun 10:00:00 |
| 2023-04-17 Mon 10:00:00 | 2023-04-18 Tue 10:00:00 | 2023-04-19 Wed 10:00:00 | 2023-04-20 Thu 10:00:00 | 2023-04-21 Fri 10:00:00 | 2023-04-22 Sat 10:00:00 | 2023-04-23 Sun 10:00:00 |
| 2023-04-24 Mon 10:00:00 | 2023-04-25 Tue 10:00:00 | 2023-04-26 Wed 10:00:00 | 2023-04-27 Thu 10:00:00 | 2023-04-28 Fri 10:00:00 | 2023-04-29 Sat 10:00:00 | 2023-04-30 Sun 10:00:00 |
Microsoft 365 與 Office | Excel | 商用版 | Windows
鎖定的問題。 此問題已從 Microsoft 支援服務社群移轉。 您可以對其是否有幫助進行投票，但無法對問題新增註解或回覆，或進行追蹤。