How To: Format dates & calculations in Excel

How to Format dates & calculations in Excel

This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a day is mapped to number one then we can represent any time of the day in the format of a decimal number between zero and one. He shows the type of formatting that excel uses to convert the decimal number into a human readable style. Now he shows various conversions

between the decimals and the real time formatting and shows how the calculations on that decimals effect the original time values. This video shows how time is represented in Excel and also shows how to perform various formatting and calculations on it.