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.
It’s Black Friday week on WonderHowTo! Don’t miss out on all of the big sales in the Gadget Hacks and Null Byte shops. And if you’ve been wanting to take some classes without going into debt, check out our best deals on online courses for a variety of skill sets. Don’t miss out on these huge discounts: