@DIME

ExcelでCONVERT関数を使って単位変換をする便利ワザ

CONVERT関数は、単位変換を自動化できる関数である。長さ・重さ・温度・時間などの単位に対応している。関数式の構文は、=CONVERT(数値, 元の単位, 変換後の単位)となる。 エクセルを活用した作業の中で、単位変換が必要になる場面は意外と多い。たとえば ...
Houston Chronicle

Conversion From Minutes & Seconds to a Decimal in Excel

Most numbers used in business are based on 10 – commonly known as the decimal system. One dollar is $1.00 and a half-dollar is $0.50. Time, of course, is an exception because it's based on 12. The day ...
Houston Chronicle

How to Make Excel Read Hours, Minutes and Seconds

While Microsoft Excel automatically reformats time values as hours and minutes, you can manually change the cell's time format to display the seconds as well. Using the Function Library on the ...