Set excel for mac to use the 1900 date system

broken image

This decimal value can help you to get varied results because now you can perform numerous operations over this returned value.Ī built-in function, categorized as a ‘Date/Time Function’, the Time function can be used as a worksheet function and can also be inserted as a part of a formula in a cell of a worksheet. Through this function, date and time values inserted in a cell gets converted to a specific decimal number. Microsoft Excel comes with various helpful Time function features, which, if known, can really save you a lot of time.

broken image

By Harshita Srivastava on Februin Basic Excel Functions and Formulas