| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Incorrect Am and Pm
I have two columns say A and B. In these two columns I enter the time in and
time out. Everything works fine till I reach 12:00 PM. Then for some reason excel forgets whether it is Am or Pm. Is there some way to get it to not switch back to Am? Second question: I also subtract the two columns to get a total time spent for each activity. If I have the start time entered in column A but no end time in column B I recieve an error message which throws off my running totals. Can I fix it so that it will not run the total until I have entered a time in column B? Thanks in advance, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| incorrect calculation | Excel Discussion (Misc queries) | |||
| "IF" formula returns zero or other incorrect number | Excel Worksheet Functions | |||
| Formulas in the spreadsheet I use as a model are now incorrect. | Excel Discussion (Misc queries) | |||
| Polynomial Formula Incorrect? | Charts and Charting in Excel | |||
| After installing SP1 for XL2003 Subtotals show incorrect result | Excel Discussion (Misc queries) | |||
Threaded Mode
