| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying negative time in excel
I have a worksheet that displays appt. time & actual time in, some of my
actual time in data is greater than the appt. time ex: 13:15 appt time, Actual time in 13:18, the cell should show :03 in red? but instead it gives me a #VALUE!. How can I display this time, and show it as a negative time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
| How do I get Excel to display a negative value for time? | Charts and Charting in Excel | |||
| Every second time i open Excel, it displays the document recovery pane | Excel Discussion (Misc queries) | |||
| time interval calculations in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
