LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Flintstone
 
Posts: n/a
Default Custom Format time to arc


I'm trying to find a symbol to Format/Cells/Custom, a symbol that
represents the max value of 360°. I know "H" is equal to the max value
of 24 hours, "m" is equal to sixty minuets and "s" is equal to sixty
seconds, this [h] will roll hours over past 24, and I know to format
cells like this h° m' s.00\" but these symbols represent time not the
arc of 360°. I want to convert arc to time and time to arc with the
symbols in costum format, I don't think this is possible, is it? Am I
doing this backwards? Should I be working with a formula or a
combination of both? I've asked other people around me who have little
or no experience wit Excel and they more or less agree that I'm
confused.

I would greatly appreciate any insight.

Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=395921

 
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
Converting to Time Format Amber Excel Discussion (Misc queries) 1 July 7th 05 10:56 PM
Keep number format after converting time to text DH Excel Discussion (Misc queries) 2 April 28th 05 07:18 PM
Custom Number Format... whitmore0112 Excel Worksheet Functions 2 January 25th 05 10:11 PM
entering numbers to display a time format Ian Williams/Eazygig Excel Discussion (Misc queries) 1 January 10th 05 11:57 AM
Custom Format and Data Validation Q John Excel Worksheet Functions 1 January 6th 05 05:56 PM


All times are GMT +1. The time now is 08:13 AM.

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

About Us

"It's about Microsoft Excel"