Inside Microsoft Excel

Display time in easy-to-add decimal form, rather than sticking with Excel’s default

Inside Microsoft Excel

by Kara Soos

Displaying time exactly the way you want can get tricky – and it’s worse when you’d like the time to display as a decimal. Often decimals work better for timesheets or other projects when you want 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 each presentation are in columns[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)