#1
|
|||
|
|||
Time calculation giving wrong results
Take a look at the last row. This is a simple time calcuation: cell C-cell B. The formula worked for all rows but the last one. All formatting is the same. What am I missing?
|
#2
|
||||
|
||||
I don't see an issue. There is a 14 hour time difference. What were you expecting?
|
#3
|
|||
|
|||
Oh, boy. Yet again Excel has proven to be smarter than I am. The first value was supposed to be 12:45 PM. Thank you for your prompt response.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Machine time cycle calculation | tmoss | Excel | 4 | 11-14-2019 08:01 AM |
Sort By Takes a Long Time to Return Results | kcolozzi | Outlook | 0 | 11-13-2018 11:18 AM |
Word Template - Userform launch from QAT giving error "Wrong number of Arguments" | dan88 | Word | 6 | 05-17-2016 10:03 AM |
Macro needed for time calculation and auto insert | ballst | Excel Programming | 8 | 05-21-2015 03:54 PM |
2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |