Excel Magic Trick 1168

Get Time Value From Date Time Value (2 Formula Examples)

DESCRIPTION

See how to Get the Time Value from a Date Time Value:
(00:08) What is a Date Time? What is a Time in Excel? What is a Date in Excel?
(01:34) INT function and Subtraction. Formula from Laza Lazarevic at YouTube.
(02:07) Copy Formula Down Huge Column Keyboard Trick
(02:25) MOD Function




Be the first to comment

Leave a Reply