Forum Discussion
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’...
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.
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.
Did you format column H as General?
