Calculate the difference in time between current time and a specific time

Question

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’t understand why.

I’ve included some pics of what is going on. Anyone have an idea of what is happening?Formulas usedError receivedRoot of the problem

hansvogelaar · Answer

taddypole&nbsp;
In F5:
=D5+TIME(0,4,0)
In F6:
=F5+TIME(0,4,0)
Fill down from F5.
Format H5 and down as General or as Number.

taddypole · Answer

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.

hansvogelaar · Answer

taddypole&nbsp;
Did you format column H as General?

snowman55 · Answer

taddypole&nbsp;Simply put, Excel cannot handle negative times (time differences or time intervals).&nbsp;But there are workarounds.&nbsp; Read the _Info worksheet and the notes on specific cells on Sheet1 of the attached workbook.

taddypole · Answer

HansVogelaar&nbsp;I have completed my project. Thank you for your help...&nbsp;

Forum Discussion

Calculate the difference in time between current time and a specific time

Share

Resources