samagonas
04-26-2018, 02:41 AM
Hi all,
I need your help. So I have specific times from which I need to subtract 6hours. Everything would be okay but when it goes past midnight it messes up. Example:
Let's say I have 20:00 in A1 and in A2 I have =A1-6/24 which would be 14:00, but if it was 00:10 in A1 and same formula in A2 it won't calculate.
I'm sure there is easy solution to this, but I can't seem to find it. I have attached screenshot if you can't understand me.
Thanks for help!
I need your help. So I have specific times from which I need to subtract 6hours. Everything would be okay but when it goes past midnight it messes up. Example:
Let's say I have 20:00 in A1 and in A2 I have =A1-6/24 which would be 14:00, but if it was 00:10 in A1 and same formula in A2 it won't calculate.
I'm sure there is easy solution to this, but I can't seem to find it. I have attached screenshot if you can't understand me.
Thanks for help!