New Horizons Get Schooled Blog

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

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).

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.

     

    Subscribe