This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / 在 ms excel里,怎么表示 40小时啊,我用 time format, 输入 40:0:0,它自动变成 16:00:00
-vetra(豆泡联盟 之 多泡泡);
2010-4-14
(#6010523@0)
-
The time format represents the time of the day.
If you mean "length of time", you may have to use number format, and the unit is "hour". So 40 hours: 40; 23 hours and 30 minutes = 23.5 hours, etc.
-sailor(Mountains&Ocean);
2010-4-14
(#6010591@0)