Calculating the duration between two dates and times in Google sheets

Рет қаралды 15,031

Yagisanatode -Scott-

Күн бұрын

Пікірлер: 29

@MayukhVerma Жыл бұрын

Thanks man. I have been searching for this for so long.

@ConsciousnessExpansionSchool Жыл бұрын

What if you want to have a cummulative overview of multiple entries and pass the 24 hr range? I cannot get the cummulative to calculate properly

@yagisanatode Жыл бұрын

I'm not 100% sur for your specific case, but one thing it might be is that the format has been changed to time instead of duration. Try Format > Number > Duration and see if that fixes your issue.

@asokoniso 2 жыл бұрын

Hi, how do I solve a problem where the sheets calculates it wrong in which the start of the work shift is at 10 pm and it ends at 2 am the next day?

@yagisanatode 2 жыл бұрын

Hi Ibrahim, Check out this tutorial! yagisanatode.com/2021/12/22/calculate-the-total-duration-of-time-between-two-periods-in-google-sheets/#Total_duration_of_time_over_multiple_days

@Narindersingh-ns7uv 2 жыл бұрын

Help me there! What's wrong with what I'm doing? I WOULD LIKE TO SEE CHANGE FROM, FOR EXAMPLE 24-12-2022 TO 24-11-2022 ITS SHOWS 29 January 1900.

@yagisanatode 2 жыл бұрын

Hmm without seeing your sheet, it sounds like you might not have set a date and only a time to the sheet. Check out the written tutorial for some more guidance: yagisanatode.com/2021/12/22/calculate-the-total-duration-of-time-between-two-periods-in-google-sheets/

@Narindersingh-ns7uv 2 жыл бұрын

@@yagisanatode thank you for reply. but in other cell formula work fine , but I want formula in two different cell

@alyssadan7127 Жыл бұрын

@@Narindersingh-ns7uv same thing happened to me, I’d you haven’t figured it out yet, you have to go to “format” then “number” then choose “duration” instead of “date”

@OrganistaAndrzej Ай бұрын

I would like to show this result in full days and hours by full days. How do I do that?

@yagisanatode Ай бұрын

What have you tried so far?

@theofficeshorts9427 2 жыл бұрын

how do I calculate or add the duration of time within a specific time period, I want to calculate pay, So I get paid a different rate between from 5am and 5pm and I get paid a different rate between 5pm and 5am night rate. could you help me with this

@theofficeshorts9427 2 жыл бұрын

also how do I calculate my hourly rate with time of hours worked

@yagisanatode 2 жыл бұрын

Both great topics. I'll add them to my tutorial list and hopefully get to them in the near future.

@theofficeshorts9427 2 жыл бұрын

@@yagisanatode do you have a formula I can use at the moment please

@yagisanatode 2 жыл бұрын

Nothing on the first but I am planning on integrating this into a current product I have hopefully early next year. On the second request, you can find the formula in my Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager Once I get a bit of time, I will probably write these two formulas up and publish a video tutorial on them.

@austinkieffer3811 2 жыл бұрын

Can you show us how this would work if we wanted to create a 15 minute step in another document as a drop down menu? I know the formula is for this document but how would it work if you wanted to add the array/sequence into an already done document to create a drop down that was 15 minute increments?

@yagisanatode 2 жыл бұрын

Hi Austin, I think I understand what you are looking for. You could create a time sequence in a separate sheet with something like I mention in this tutorial: kzbin.info/www/bejne/eWTYXph5a7dlqJY an then use IMPORTRANGE to draw that data across to another Google Sheet. Here is a tutorial on IMPORTRANGE to help there kzbin.info/www/bejne/fmXYfnajmdWhq8U