ByTheKeySt
Hello everyone, I would like to have a list in column R of the employee hours/minutes worked in the respective hourly periods.
(Google Sheets)
Do you have a suitable formula for me?
(1 votes)
Loading...There is increasing evidence that this is true. The evidence is: Newspapers even write national articles, e.g. Süddeutsche Zeitung Google already has an AI My questions are: What happens to the websites? How much do the websites earn from this? Will this backfire?
My DELL laptop / Windows 11 once again does not recognize the connected headphones, which otherwise works. I should probably update the driver. However, I only have my laptop set to "Spanish language". How can I update the sound card driver?
Hello dear community, I have normal mode in MS WORD, EXCEL etc. but dark mode in Outlook, for example. Unfortunately, I can only change one option in the settings for the entire Office. Am I missing something? Or is there a trick?
Windows 12 is finally supposed to be released this year. There were constant complaints about Windows 11, and despite recently getting a newer computer, which gives me more RAM and hard drive capacity and makes some video games less laggy, I'm still using Windows 10, which works really well on all the devices that still…
Hello there, I'm currently in the process of buying a laptop. Do you think it makes sense to buy one from Huawei, or do you think I might run into problems with it in the future? (Since Huawei phones no longer have Google) Thank you!
Format of cells in column R: [hh]:mm
then you write in R4 =DC and press Ctrl+Enter
then you drag it down with the 🐁. So to the corner of the cell bottom right so that the cursor becomes a cross and drag it down
does not include the employees of the duty roster in U5:X15
huh, like now. You might need to describe in more detail what you want to do. What those sections are in the table on the left. I just see that it's continuous. I don't understand what you want to do.
oh so that's Excel but it should work like this otherwise just look for the equivalent
Yes, Excel is mostly similar to Google Sheets, but you didn't quite understand the task. In the time period 7:00-8:00, i.e., in R4, the total hours currently being worked according to the roster should be displayed. In this example, 1.5 hours, since three employees have already been working since 7:30.
So you want to calculate the total number of hours worked between, say, 6 and 7? Then you would need to know who worked during that time. But calculating that for each hour is nonsense. Normally, you would determine how much each employee worked in a day and add it all up.
oh now. yes then it doesn't work like that
Would you like to have in column R how many hours/minutes in total were worked from 7:00-8:00, from 8:00-9:00, etc.?
Yes, that is possible, but it will be very extensive.
Yes, right. Extensive sounds sobering, of course.