Download Excel Start File: [ Ссылка ]

Download File: [ Ссылка ]
See how to Get the Time Value from a Date Time Value:
1. (00:08 minute mark) What is a Date Time? What is a Time in Excel? What is a Date in Excel?
2. (01:34 minute mark) INT function and Subtraction. Formula from Laza Lazarevic at YouTube.
3. 02:07 minute mark) Copy Formula Down Huge Column Keyboard Trick
4. (02:25 minute mark) MOD Function

свернуть