Excel Guides

Converting Time Notation to Decimal Notation in Excel

Converting time notation to decimal notation in Excel is a relatively simple process. The first thing you need to do is make sure that your time values are formatted as text. To do this, select the cells containing your time values and then click on the 'Format' drop-down menu at the top of the screen. In the 'Format Cells' dialogue box that appears, select the 'Number' tab and then choose the 'Text' option from the 'Category' list. Click 'OK' to close the dialogue box and apply the changes.

Once your time values are formatted as text, you can use Excel's 'FIND' and 'REPLACE' functions to convert them to decimal notation. To do this, open the 'Find and Replace' dialogue box by pressing CTRL+F on your keyboard (or by going to the 'Home' tab and clicking on the 'Find & Select' button). In the 'Find what:' field, type in a colon (:) and then press the 'Replace with:' field. Type in a period (.) and then click on the 'Replace All' button.

Your time values should now be in decimal notation!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.