Forum Discussion
taddypole
Feb 12, 2024Copper Contributor
Calculate the difference in time between current time and a specific time
I’m trying to find the time difference between an incremented time based on the start time I enter and the real time clock I created. When I try to find the difference value, I get an error and don’...
taddypole
Feb 18, 2024Copper Contributor
Thanks Hans... that was a better formula for Column F calculations but I'm still having problems with the column H calculation. As you can see in the pics, I'm getting some sort of error using the formulas in column H. I'm guessing it is some form of time formatting issues but don't know how to fix it.
SnowMan55
Feb 19, 2024Bronze Contributor
Simply put, Excel cannot handle negative times (time differences or time intervals).
But there are workarounds. Read the _Info worksheet and the notes on specific cells on Sheet1 of the attached workbook.