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 and you'd like the durations of each presentation displayed in column E in decimal form (e.g., 1.25 instead of 1:15).
Display time the way YOU want it in Excel
Posted on 4/16/13 4:24 PM by Get Schooled in Display Time, in Excel, in Microsoft, in Tips & Tricks