Dec 14 2022 09:06 PM
Hi,
I am trying to create a sheet where you put in the date, start time and finish time, time spent, lieu hours, math (Add/Subtract) and current hours.
Example
Date: 15th December 2022
Start Time: 8:30am
Finish Time: 6pm
Time Spent: 9hrs 30mins
Lieu Hours: 2 hours (Overtime hours)
Math: Add
Current Hours: 2 hours
If I have a longer lunch, I add it to Time In Lieu and put it in the sheet.
Time Spent: 30mins
Lieu Hours 0:30
Math: Subtract
Current Hours: 1:30
Any help would be great, thanks.
I just need to do the Current hours, I've gotten the Lieu Hours just need help doing the text do math.
Thanks,
Andrew
Dec 15 2022 12:42 PM
You've had 60 views as of this writing, but no replies. I suspect that lack of response is because it's really not at all clear what you are asking to do. Something along the lines of "If I enter the word 'subtract' I want Excel to do that subtraction." And./Or "If I enter the word 'add' then it should do addition."
But your examples don't make sense: what exactly are we adding to produce what number? What are we subtracting to produce what number? And so forth.
I'm sure it's all clear to YOU, and therefore you think it's clear. But, sorry to say it, it ain't!!
Dec 15 2022 01:45 PM
Dec 15 2022 03:51 PM
What is not clear is what numbers are to be added, subtracted in order to produce what results. You need to give some clear examples. Multiple examples.
Here's what you've written
Example
Date: 15th December 2022
Start Time: 8:30am
Finish Time: 6pm
Time Spent: 9hrs 30mins
Lieu Hours: 2 hours (Overtime hours) I believe, based on your most recent comment, that
this is because you went two hours beyond 4 p.m.
Is that correct?
There's no indication of that, however,
in your first example. It just appears
and is labeled as "Leiu Hours"
Math: Add Add what to what??
Current Hours: 2 hours Where does this number come from?
You then went on to offer this:
If I have a longer lunch, I add it to Time In Lieu and put it in the sheet.
Time Spent: 30mins
Lieu Hours 0:30
Math: Subtract Subtract what from what?
Current Hours: 1:30 Is this the result of subtracting 30 from the 2 hours
above?
It probably is, but you were assuming
that is obvious when it isn't.
Since you have some of it resolved already, would you please post a copy of what you have done already. It would make it easier to fit what is missing into what you already have. Put a copy on GoogleDrive and past a link here that grants access.
Dec 15 2022 04:08 PM
Dec 15 2022 06:03 PM
NO issues with accessing the Google Doc. Thank you.
But I don't understand what it is you want done. And, quite frankly, don't understand why you don't just write the formula that DOES the adding or subtracting. You clearly know how to write formulas.
But if you wish help, please describe in words, now, based on the data in the various columns of that Google Spreadsheet,
what columns you'd want to have added when the word in Column E is "Add" and
what columns would be involved in subtraction, when the word is "Subtract"
It seems as if it's the IF or IFS function that you are wanting help with....so spell out in words
IF (E3="Add",.... then (do this, in words)
IF (E4-"Subtract"...then (do this, in words)
Dec 15 2022 06:04 PM
NO issues with accessing the Google Doc. Thank you.
But I don't understand what it is you want done. And, quite frankly, don't understand why you don't just write the formula that DOES the adding or subtracting. You clearly know how to write formulas.
But if you wish help, please describe in words, now, based on the data in the various columns of that Google Spreadsheet,
what columns you'd want to have added when the word in Column E is "Add" and
what columns would be involved in subtraction, when the word is "Subtract"
It seems as if it's the IF or IFS function that you are wanting help with....so spell out in words
IF (E3="Add",.... then (do this, in words)
IF (E4-"Subtract"...then (do this, in words)
Dec 18 2022 04:46 PM