| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel formatting
PLEASE HELP! I have used the 00:\00:\00 format to input times without having
to press the colon every time. Now though, when Excel tries to minus one time from another, because of this formatting it only recognises times as numbers, e.g. 12:15:30 - 12:14:50 Excel thinks this equals 00:00:80 !! Can anybody help?! How do I get it to recognise that the answer is 00:01:20 ??? thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel could not save all the data and formatting you recently ad.. | Excel Worksheet Functions | |||
| Formatting a excel sheet that has been created using DTS. | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| Lotus 123 save as excel workbook and maintain formatting? | Excel Discussion (Misc queries) | |||
| Lotus 123 save as excel workbook and maintain formatting? | Excel Discussion (Misc queries) | |||
Threaded Mode
