L
Lynn Teague
Hello,
I would like to automatically put the following number
string into a readable date and time format and then I
would like to do a time subtraction (against another
number string) - any ideas?
Here is the first number string:
20030205171721 where:
2003 = the year
02 = the month
05 = the day
17 = the hour
17 = the minutes
21 = the seconds
Here is the second number string:
20030205181011 where:
2003 = the year
02 = the month
05 = the day
18 = the hour
10 = the minutes
11 = the seconds
What I am looking for exactly is a formula that will work
out the number of minutes difference between number string
1 and number string 2 - in this case it would be 53
minutes (rounded to the nearest minute).
Any ideas?
Thank you in advance.
I would like to automatically put the following number
string into a readable date and time format and then I
would like to do a time subtraction (against another
number string) - any ideas?
Here is the first number string:
20030205171721 where:
2003 = the year
02 = the month
05 = the day
17 = the hour
17 = the minutes
21 = the seconds
Here is the second number string:
20030205181011 where:
2003 = the year
02 = the month
05 = the day
18 = the hour
10 = the minutes
11 = the seconds
What I am looking for exactly is a formula that will work
out the number of minutes difference between number string
1 and number string 2 - in this case it would be 53
minutes (rounded to the nearest minute).
Any ideas?
Thank you in advance.