Inside Microsoft Excel

Display time in easy-to-add decimal form, rather than sticking with Excel’s default (2000/2002/2003/2004/2007/2010/2013)

by Kara Hiltz

Displaying time exactly the way you want can be tricky-and it gets even more confusing when you’d like the time to display as a decimal. Often decimals work better for timesheets or other projects when you want to be able to add values together to determine how long you’ve spent on a project. Let’s say you have a worksheet displaying the agenda for a business conference. The start and end times of[…]