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.