Display time in easy-to-add decimal form, rather than sticking with Excel’s default
by Kara Soos
Application:
Microsoft Excel 2000/2002/2003/2004/2007
Operating Systems:
Microsoft Windows, Macintosh
Download:
http://download.elijournals.com/excel/201003/agenda.zip
I have a spreadsheet that includes several time values. However, when I need to add or subtract these times, their standard format doesn’t cut it. Do you know how I can change my times to display as decimals?
Lynn Erwin
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 each presentation are in columns C and D, as shown on the left in
