Hi
I would like to format a cell with hours and minutes for example 8:15 would be 8 hrs & 15 mins.
Please see attached
Many Thanks
Braddy
Results 1 to 3 of 3
Thread: Format hr:mm (Excel 2002/2003)
-
Silver Lounger
- Join Date
- Dec 2000
- Location
- Northampton, Northamptonshire, England
- Posts
- 1,911
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-08-29 08:49Format hr:mm (Excel 2002/2003)
If you are a fool at forty, you will always be a fool
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2006-08-29 08:54Re: Format hr:mm (Excel 2002/2003)
Select Custom in the list of Categories and enter <code>h "hrs" m "mins"</code> in the Type box. The quotes around the text parts are necessary, otherwise the h in hrs will be interpreted as hours, the s as seconds, etc.
-
Silver Lounger
- Join Date
- Dec 2000
- Location
- Northampton, Northamptonshire, England
- Posts
- 1,911
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-08-29 09:18Re: Format hr:mm (Excel 2002/2003)
Hi Hans
Once again Thanks very much.
BraddyIf you are a fool at forty, you will always be a fool
