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

Copper 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’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

5 Replies

# Re: Calculate the difference in time between current time and a specific time

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.

# Re: Calculate the difference in time between current time and a specific time

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.

# Re: Calculate the difference in time between current time and a specific time

Did you format column H as General?

# Re: Calculate the difference in time between current time and a specific time

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.

# Re: Calculate the difference in time between current time and a specific time

I have completed my project. Thank you for your help...