| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
figure out why this formula isn't calculating correctly
If you right-click on a cell you can access custom formats via the format
cells option. Just enter h:mm and it returns 24 hour time. -- Brevity is the soul of wit. "kcain" wrote: I noticed above that you said you changed the format to h:mm. How did you change the format to time? Thanks, KCain http://www.excelsecrets.com/photoshop/index.php -- kcain ------------------------------------------------------------------------ kcain's Profile: http://www.excelforum.com/member.php...o&userid=37907 View this thread: http://www.excelforum.com/showthread...hreadid=574323 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekday formula calculating to end of month | Excel Worksheet Functions | |||
| CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES | Excel Worksheet Functions | |||
| formula returns (correctly) a negative value | Excel Discussion (Misc queries) | |||
| Formula for calculating age | Excel Discussion (Misc queries) | |||
| How do figure excel formula out? | Excel Discussion (Misc queries) | |||
Threaded Mode
