|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 15th, 2005, 03:09 AM
|
|||
|
|||
How do I display the h:mm minutes in hundreds?
My company uses a time clock that uses hundredths of an hour rather than
minutes. Is there a way to display the h:mm in hundreths rather than minutes without having to convert the time to minutes first, so that I can use the time functions in the graphing and charting? 
|
|
#2
January 15th, 2005, 03:54 AM
|
|||
|
|||
|
Multiply with 24 and format as general, I.e. you have 2:30 in a cell but
want 2.5 instead -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "dpackwood" wrote in message news  My company uses a time clock that uses hundredths of an hour rather than minutes. Is there a way to display the h:mm in hundreths rather than minutes without having to convert the time to minutes first, so that I can use the time functions in the graphing and charting?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| adding minutes (> 60 ) to military time | grilla79 | General Discussion | 6 | October 8th, 2004 02:17 AM |
| Displaying total minutes in the form of hours and minutes | M | Worksheet Functions | 0 | August 2nd, 2004 07:40 PM |
| Displaying total minutes in the form of hours and minutes | M | Worksheet Functions | 0 | August 2nd, 2004 07:40 PM |
| how do I reduce the size of the outlook calendar time display? | Nina Harris | General Discussion | 0 | July 22nd, 2004 02:54 PM |
| Display Database Window | Dave | New Users | 2 | July 10th, 2004 03:23 PM |
Linear Mode
