Forum Discussion
pace36
Apr 14, 2019Copper Contributor
Time formula please...
Can anyone help me with a time formula. Left hand columns are example of what I'm trying to achieve. HW Oban changes daily (manually input) all other locations change automatically through formula....
SergeiBaklan
Apr 14, 2019Diamond Contributor
pace36 ,
You need to convert your texts with time difference into the time (which is actually decimal number) and taking into account what time is always shall be positive.
That could be like
=$H$2+IF(MID(G7,2,1)="-",-1,1)*MID(G7,3,LEN(G7)-3)
pace36
Apr 14, 2019Copper Contributor
Works a treat - Thank you!
- SergeiBaklanApr 15, 2019Diamond Contributor
pace36 , you are welcome