Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Time Calculations

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default Time Calculations

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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,420
Default Time Calculations

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Calculations Mark Excel Worksheet Functions 11 October 16th 08 07:32 PM
Time difference calculations, daylight savings time, Excel Tim Excel Discussion (Misc queries) 1 December 28th 06 04:18 PM
Overlapping time calculations and automatic time updates Arlette Excel Worksheet Functions 1 December 9th 06 12:20 AM
Time Calculations Jai_Friday Excel Worksheet Functions 4 July 18th 06 11:45 AM
convert time imported as text to time format for calculations batfish Excel Worksheet Functions 3 October 27th 05 11:24 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"