资讯

Excel has several custom formatting options for duration of time, and it will recognize most times you enter, provided you use a colon between the hours, minutes and seconds.
Convert to currency. This option will left-align the dollar symbol and right-align the number. Technically, this is referred to as Accounting formatting.