Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2023, 02:30 PM
thelighthouse thelighthouse is offline Time calculation giving wrong results Windows 10 Time calculation giving wrong results Office 2016
Advanced Beginner
Time calculation giving wrong results
 
Join Date: Jun 2017
Posts: 42
thelighthouse is on a distinguished road
Default 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?
Attached Images
File Type: jpg Laura hours Excel.jpg (57.3 KB, 5 views)
Reply With Quote
  #2  
Old 12-28-2023, 02:36 PM
Alansidman's Avatar
Alansidman Alansidman is offline Time calculation giving wrong results Windows 11 Time calculation giving wrong results Office 2021
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

I don't see an issue. There is a 14 hour time difference. What were you expecting?
Reply With Quote
  #3  
Old 12-28-2023, 02:54 PM
thelighthouse thelighthouse is offline Time calculation giving wrong results Windows 10 Time calculation giving wrong results Office 2016
Advanced Beginner
Time calculation giving wrong results
 
Join Date: Jun 2017
Posts: 42
thelighthouse is on a distinguished road
Default

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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Time calculation giving wrong results 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
Time calculation giving wrong results 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft