Time Calculations

J

jacsdad

In Excel 2007, I am attempting to calculate the difference between two times.
I have read the instructions in Help and found what I need to do, but cannot
fine where to format the Category to Customize to: [h]:mm.

On the Home tab, in the Cells group, click Format, and then click Format
Cells.
In the Format Cells dialog box, click the Number tab.
Under Category, click Custom.
In the Type box, type [h]:mm.

Thanks ahead of time...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top