Calculating total salary with Libre Office Calc
I store my working time in Libre Office Calc like this:
Start End Hours
10:00 15:00 05:00
11:00 14:00 03:00
09:30 15:30 06:00
Total
14:00
Now I want to calculate my salary, i.e. multiply the total hours with for example 10 (salary per 1 hour).
When I try:
=G2*10 // (G2 is the cell with the total hours 14:00)
I get a total salary of 5,83 € (the cell is already formatted as currency). I don't know where this strange amount comes from.
worksheet-function libreoffice libreoffice-calc
add a comment |
I store my working time in Libre Office Calc like this:
Start End Hours
10:00 15:00 05:00
11:00 14:00 03:00
09:30 15:30 06:00
Total
14:00
Now I want to calculate my salary, i.e. multiply the total hours with for example 10 (salary per 1 hour).
When I try:
=G2*10 // (G2 is the cell with the total hours 14:00)
I get a total salary of 5,83 € (the cell is already formatted as currency). I don't know where this strange amount comes from.
worksheet-function libreoffice libreoffice-calc
What is the unformatted (or number formatted) value of G2? Dates/times can be handled a little goofy in spreadsheet programs.
– Foosh
Jan 8 '15 at 23:03
add a comment |
I store my working time in Libre Office Calc like this:
Start End Hours
10:00 15:00 05:00
11:00 14:00 03:00
09:30 15:30 06:00
Total
14:00
Now I want to calculate my salary, i.e. multiply the total hours with for example 10 (salary per 1 hour).
When I try:
=G2*10 // (G2 is the cell with the total hours 14:00)
I get a total salary of 5,83 € (the cell is already formatted as currency). I don't know where this strange amount comes from.
worksheet-function libreoffice libreoffice-calc
I store my working time in Libre Office Calc like this:
Start End Hours
10:00 15:00 05:00
11:00 14:00 03:00
09:30 15:30 06:00
Total
14:00
Now I want to calculate my salary, i.e. multiply the total hours with for example 10 (salary per 1 hour).
When I try:
=G2*10 // (G2 is the cell with the total hours 14:00)
I get a total salary of 5,83 € (the cell is already formatted as currency). I don't know where this strange amount comes from.
worksheet-function libreoffice libreoffice-calc
worksheet-function libreoffice libreoffice-calc
edited Jan 14 at 10:03
Toto
3,763101226
3,763101226
asked Jan 8 '15 at 22:58
user1170330user1170330
1105
1105
What is the unformatted (or number formatted) value of G2? Dates/times can be handled a little goofy in spreadsheet programs.
– Foosh
Jan 8 '15 at 23:03
add a comment |
What is the unformatted (or number formatted) value of G2? Dates/times can be handled a little goofy in spreadsheet programs.
– Foosh
Jan 8 '15 at 23:03
What is the unformatted (or number formatted) value of G2? Dates/times can be handled a little goofy in spreadsheet programs.
– Foosh
Jan 8 '15 at 23:03
What is the unformatted (or number formatted) value of G2? Dates/times can be handled a little goofy in spreadsheet programs.
– Foosh
Jan 8 '15 at 23:03
add a comment |
1 Answer
1
active
oldest
votes
If you view your 14:00 hours in their stored form, you will see 0,583333333333333; times are stored as fraction of a day and formatted to appear as common units. The number comes from division of 14 hours by 24 hours in a day; 14/24=0.58333
. So if you multiply by 10 you get 5,83 €.
The answer is to change your formula to turn the fraction of a day into number of hours:
=G2*24*10
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fsuperuser.com%2fquestions%2f862437%2fcalculating-total-salary-with-libre-office-calc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you view your 14:00 hours in their stored form, you will see 0,583333333333333; times are stored as fraction of a day and formatted to appear as common units. The number comes from division of 14 hours by 24 hours in a day; 14/24=0.58333
. So if you multiply by 10 you get 5,83 €.
The answer is to change your formula to turn the fraction of a day into number of hours:
=G2*24*10
add a comment |
If you view your 14:00 hours in their stored form, you will see 0,583333333333333; times are stored as fraction of a day and formatted to appear as common units. The number comes from division of 14 hours by 24 hours in a day; 14/24=0.58333
. So if you multiply by 10 you get 5,83 €.
The answer is to change your formula to turn the fraction of a day into number of hours:
=G2*24*10
add a comment |
If you view your 14:00 hours in their stored form, you will see 0,583333333333333; times are stored as fraction of a day and formatted to appear as common units. The number comes from division of 14 hours by 24 hours in a day; 14/24=0.58333
. So if you multiply by 10 you get 5,83 €.
The answer is to change your formula to turn the fraction of a day into number of hours:
=G2*24*10
If you view your 14:00 hours in their stored form, you will see 0,583333333333333; times are stored as fraction of a day and formatted to appear as common units. The number comes from division of 14 hours by 24 hours in a day; 14/24=0.58333
. So if you multiply by 10 you get 5,83 €.
The answer is to change your formula to turn the fraction of a day into number of hours:
=G2*24*10
edited Jan 14 at 8:53
fixer1234
18.6k144782
18.6k144782
answered Jan 8 '15 at 23:03
DavidenkoDavidenko
1,14331529
1,14331529
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f862437%2fcalculating-total-salary-with-libre-office-calc%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
What is the unformatted (or number formatted) value of G2? Dates/times can be handled a little goofy in spreadsheet programs.
– Foosh
Jan 8 '15 at 23:03