• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

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 $
0
sandramac
Asked:
sandramac
1 Solution
 
barry houdiniCommented:
You just want the hour or the day as well? If it's the hour and the format is always consistent then try this formula for the hour - inserted in sheet14 cell A1

=MOD(MID(Sheet13!A1,8,2)+1,24)

If the format is not consistent then can you show more example?

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now