|
|
#1
12-28-2023, 02:30 PM
|
|||
|
|||
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
12-28-2023, 02:36 PM
|
||||
|
||||
|
I don't see an issue. There is a 14 hour time difference. What were you expecting?
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2510
|
|
#3
12-28-2023, 02:54 PM
|
|||
|
|||
|
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.
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Linear Mode
