Calculate percentage from two date/time stamps bash
Clash Royale CLAN TAG#URR8PPP
I have two files "DURATION.txt" and "ABCDURATION.txt" which contain ~900 records where DURATION.txt is the total runtime and "ABCDURATION.txt" is a portion of that total. What I need to do is calculate the percentage of total using these two files.
DURATION.txt EXAMPLE:
0h:2m:54s
0h:6m:17s
1h:55m:42s
1h:5m:9s
...
ABCDURATION.txt EXAMPLE
0h:0m:31s
0h:0m:28s
1h:54m:34s
1h:4m:7s
0h:22m:6s
...
That said I was able to make awk work to accomplish this but not from the DATE/TIME stamp only with whole numbers
Example:
awk 'NR==FNRt+=$1;nextprintf("%d%sn", $1/t*100, "%")' ABCDURATION.txt DURATION.txt
This yields a whole number followed by the "%" sign. e.g. 50%
My question is can I do such a calculation using the TIME/DATE stamps or do I have to convert to seconds or something like that?
bash awk timestamps
edited Jan 10 at 20:13
Emilio Galarraga
51929
asked Jan 10 at 13:19
SSDdudeSSDdude
727
add a comment |
I have two files "DURATION.txt" and "ABCDURATION.txt" which contain ~900 records where DURATION.txt is the total runtime and "ABCDURATION.txt" is a portion of that total. What I need to do is calculate the percentage of total using these two files.
DURATION.txt EXAMPLE:
0h:2m:54s
0h:6m:17s
1h:55m:42s
1h:5m:9s
...
ABCDURATION.txt EXAMPLE
0h:0m:31s
0h:0m:28s
1h:54m:34s
1h:4m:7s
0h:22m:6s
...
That said I was able to make awk work to accomplish this but not from the DATE/TIME stamp only with whole numbers
Example:
awk 'NR==FNRt+=$1;nextprintf("%d%sn", $1/t*100, "%")' ABCDURATION.txt DURATION.txt
This yields a whole number followed by the "%" sign. e.g. 50%
My question is can I do such a calculation using the TIME/DATE stamps or do I have to convert to seconds or something like that?
bash awk timestamps
edited Jan 10 at 20:13
Emilio Galarraga
51929
asked Jan 10 at 13:19
SSDdudeSSDdude
727
add a comment |
I have two files "DURATION.txt" and "ABCDURATION.txt" which contain ~900 records where DURATION.txt is the total runtime and "ABCDURATION.txt" is a portion of that total. What I need to do is calculate the percentage of total using these two files.
DURATION.txt EXAMPLE:
0h:2m:54s
0h:6m:17s
1h:55m:42s
1h:5m:9s
...
ABCDURATION.txt EXAMPLE
0h:0m:31s
0h:0m:28s
1h:54m:34s
1h:4m:7s
0h:22m:6s
...
That said I was able to make awk work to accomplish this but not from the DATE/TIME stamp only with whole numbers
Example:
awk 'NR==FNRt+=$1;nextprintf("%d%sn", $1/t*100, "%")' ABCDURATION.txt DURATION.txt
This yields a whole number followed by the "%" sign. e.g. 50%
My question is can I do such a calculation using the TIME/DATE stamps or do I have to convert to seconds or something like that?
bash awk timestamps
edited Jan 10 at 20:13
Emilio Galarraga
51929
asked Jan 10 at 13:19
SSDdudeSSDdude
727
I have two files "DURATION.txt" and "ABCDURATION.txt" which contain ~900 records where DURATION.txt is the total runtime and "ABCDURATION.txt" is a portion of that total. What I need to do is calculate the percentage of total using these two files.
DURATION.txt EXAMPLE:
0h:2m:54s
0h:6m:17s
1h:55m:42s
1h:5m:9s
...
ABCDURATION.txt EXAMPLE
0h:0m:31s
0h:0m:28s
1h:54m:34s
1h:4m:7s
0h:22m:6s
...
That said I was able to make awk work to accomplish this but not from the DATE/TIME stamp only with whole numbers
Example:
awk 'NR==FNRt+=$1;nextprintf("%d%sn", $1/t*100, "%")' ABCDURATION.txt DURATION.txt
This yields a whole number followed by the "%" sign. e.g. 50%
My question is can I do such a calculation using the TIME/DATE stamps or do I have to convert to seconds or something like that?
bash awk timestamps
bash awk timestamps
edited Jan 10 at 20:13
Emilio Galarraga
51929
asked Jan 10 at 13:19
SSDdudeSSDdude
727
edited Jan 10 at 20:13
Emilio Galarraga
51929
asked Jan 10 at 13:19
SSDdudeSSDdude
727
edited Jan 10 at 20:13
Emilio Galarraga
51929
edited Jan 10 at 20:13
Emilio Galarraga
51929
edited Jan 10 at 20:13
Emilio Galarraga
51929
51929
asked Jan 10 at 13:19
SSDdudeSSDdude
727
asked Jan 10 at 13:19
SSDdudeSSDdude
727
asked Jan 10 at 13:19
SSDdudeSSDdude
727
727
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f493711%2fcalculate-percentage-from-two-date-time-stamps-bash%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Unix & Linux Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f493711%2fcalculate-percentage-from-two-date-time-stamps-bash%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
