| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours and minutes | Excel Worksheet Functions | |||
| Adding minutes to time | Excel Discussion (Misc queries) | |||
| add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
| How do I get a cell to display degrees, minutes, seconds? | Excel Worksheet Functions | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
