How to Add Time in Google Sheets (Add Hours, Minutes, Seconds)
68 هزار بار بازدید -
3 سال پیش
-
In this video, we will
In this video, we will show you how to add time in Google Sheets.
In this sheet, we have a timestamp for clock in, and now we want to add the hours, minutes and seconds worked during the day to find out the clock out timestamp.
First, we would need to determine the correct format to enter the hours, minutes and seconds in the sheet.
To get started, let’s simply click on where we want the total to appear, and add the start time with the hours, minutes and seconds over here.
Now for example, if the resource has worked for 8 hours, we cannot simply enter 8 over here. You can see that the end result is incorrect.
To make sure the number represents hours, we need to divide it by twenty four. So let’s select the cell and enter the “equals to” sign. Then enter eight followed by the divide symbol and entering twenty four.
Once we hit enter, you can see that the clock out timestamp correctly determines the time.
Similarly there are sixty minutes in an hour, so while entering minutes make sure you divide the number by twenty four, for the number of hours in a day, and then sixty, to account for the number of minutes in an hour.
Now for seconds, we will need to divide the number by both the number of hours in a day along with the number of minutes in an hour and the number seconds in a minute. That’s why we have divided the number by twenty four and twice by sixty.
You can see the clock out time is updated accordingly.
Now let’s select the hours, minutes and seconds and open up the formatting tab. You can select the duration option here to show the correct formatting.
You can carry on by using the same formulas to add hours, minutes and seconds within your calculation.
That’s all!
❓💬 Would you like to know about any particular Google Sheets feature? Let us know in the comments below.
#HowTech #GoogleSheets
--------------------------------------------------------------------------------------------------------------
✅ All our announcements are available here t.me/howtechtv
✅ Commercial questions [email protected]
✅ Facebook www.facebook.com/howtechtv
✅ Instagram www.instagram.com/howtechprojects
✅ Twitter twitter.com/howtechprojects
3 سال پیش
در تاریخ 1400/09/19 منتشر شده
است.
68,016
بـار بازدید شده