Substracting a fixed number of hours to a time

Hi,

I have the following problem, I have looked through the tips section but I am thinking none of these tips adjust specifically to my need and I am not entirely capable of coming out with my own solution

I have a column filled with times in hh:mm format, all of these times have been pulled out from a server in a different location and therefore they have +6 hours. I want to come out with a formula that will substract 6 hours to all of these times

IE.

06:08 should be 00:08
13:00 should be 07:00
04:00 should be 22:00 of the day before although I can find a way to avoid this complication manually.

I really appreciate your help with this!

Paulo C.

Originally Posted by PauloCR

Hi,

I have the following problem, I have looked through the tips section but I am thinking none of these tips adjust specifically to my need and I am not entirely capable of coming out with my own solution

I have a column filled with times in hh:mm format, all of these times have been pulled out from a server in a different location and therefore they have +6 hours. I want to come out with a formula that will substract 6 hours to all of these times

IE.

06:08 should be 00:08
13:00 should be 07:00
04:00 should be 22:00 of the day before although I can find a way to avoid this complication manually.

I really appreciate your help with this!

Paulo C.

Hi PauloCR,

Try this formula

=A1+24-0.25

oldchippy

Thanks Oldchippy!

However I am confused about something, here are some of the results I got:

1:08 18:00
2:17 19:08
2:27 20:17
4:25 20:27
5:50 22:25
11:42 23:50

As you can see some of the minutes are being modified too and the hours difference is not correct.

Thanks so much

Originally Posted by PauloCR

Thanks Oldchippy!

However I am confused about something, here are some of the results I got:

1:08 18:00
2:17 19:08
2:27 20:17
4:25 20:27
5:50 22:25
11:42 23:50

As you can see some of the minutes are being modified too and the hours difference is not correct.

Thanks so much

It works on mine OK, are you sure all cells are formatted hh:ss? Are just these the problem or are all causing trouble?

yes, small error on my part! it works great.

Thanks so much oldchippy!

Good, thanks for the feedback