Hi All
I've learned quite a lot about working with dates but never worked with times.
I have to do some tidal calculations and need to calculate a time 3 hours and 5 mins before high water (I literally have to deduct 3 hours and 5 mins from the high water time which I have in column B) the problem is that if the high water time is say 02.30 hrs, deducting 3 hours and 5 mins the date would be the day before, the dates are in column A.
What I would like to do is in column E have the correct date, the date will always be the same as that in column A unless deducting 3 hours and 5 mins moves it back to day before and enter this in column F have the revised time.
Sounds simple
, I've been at this all afternoon going around in ever decreasing circles and not getting anywhere.
Is there a simple solution to this?? I am on the verge of throwing my laptop out of the window.
Any help would be greatly appreciated
Cheers
Paul
I've learned quite a lot about working with dates but never worked with times.
I have to do some tidal calculations and need to calculate a time 3 hours and 5 mins before high water (I literally have to deduct 3 hours and 5 mins from the high water time which I have in column B) the problem is that if the high water time is say 02.30 hrs, deducting 3 hours and 5 mins the date would be the day before, the dates are in column A.
What I would like to do is in column E have the correct date, the date will always be the same as that in column A unless deducting 3 hours and 5 mins moves it back to day before and enter this in column F have the revised time.
Sounds simple
Is there a simple solution to this?? I am on the verge of throwing my laptop out of the window.
Any help would be greatly appreciated
Cheers
Paul
Last edited: