Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... -- jacsdad |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
It's difficult to improve on Help's instructions. That's exactly what you
need to do. You need to tell us at what point you can't follow the instructions. If you want a different way, right-click on your cell, choose Format Cells... That will take you to the Format Cells dialog box. Follow the instructions from there. Regards, Fred. "jacsdad" wrote in message ... 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... -- jacsdad |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Category is the list on the left on the Number tab.
-- __________________________________ HTH Bob "jacsdad" wrote in message ... 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... -- jacsdad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Calculations | Excel Worksheet Functions | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
Time Calculations | Excel Worksheet Functions | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions |