sandramac
asked on
Time Conversion
I have data in sheet 13 cell a1 (see below). I need to extract the time out of this data, which is 031752Z which is 03 is the 3rd day and 1752 is 1752 UTC time. I am trying to take the hour which would be 17 and add 1 hour to it to get 18. Then place that value in sheet 14 cell a1.
A1:
KOKC 031752Z 16009KT 10SM OVC250 24/15 A2996 RMK AO2 SLP134 T02440150 10244 20139 58011 $
A1:
KOKC 031752Z 16009KT 10SM OVC250 24/15 A2996 RMK AO2 SLP134 T02440150 10244 20139 58011 $
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.