Hi,
I import times in CEST in the following format - 19:00:00
I want to apply a change to all of these to remove one hour and make it GMT time
How do I go about this?
Thanks
Hi,
I import times in CEST in the following format - 19:00:00
I want to apply a change to all of these to remove one hour and make it GMT time
How do I go about this?
Thanks
Maybe..
=A1-1/24
Format as h:mm:ss
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks