| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time conversion
I want to set a formula in conditional formatting and convert all time
figures (hh:mm) in to normal numbering. Basically I want 12 hrs and 30 minutes to appear 12.50 Is this possible. -- Peace in the world |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time conversion
=(MOD(G2,1))*24 formatted as 00.00
-- Don Guillett SalesAid Software "Seaman" wrote in message ... I want to set a formula in conditional formatting and convert all time figures (hh:mm) in to normal numbering. Basically I want 12 hrs and 30 minutes to appear 12.50 Is this possible. -- Peace in the world |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time conversion | Excel Discussion (Misc queries) | |||
| Time Conversion | Excel Discussion (Misc queries) | |||
| Time conversion | Excel Worksheet Functions | |||
| time conversion | Excel Discussion (Misc queries) | |||
| Time conversion | Excel Worksheet Functions | |||
Hybrid Mode
